sql语句培训.pptVIP

ORACLE数据库 2008年10月 中国电力科学院配电与农电研究院 SQL语句培训 （一）四类SQL语句 1、数据表创建语句 创建员工数据表: CREATE TABLE Employee (Em_id number(8), Em_name varchar(20), dp_id number(8)， salary number(6)); 插入演示数据: INSERT INTO Employee VALUES(1,陈红卫,1,4000); INSERT INTO Employee VALUES(2,骆誉明,1,2800); INSERT INTO Employee VALUES(3,汪金海,2,5000); INSERT INTO Employee VALUES(4,王敏,2,3500); INSERT INTO Employee VALUES(5,杜康乐,2,1800); INSERT INTO Employee VALUES(6,赵方,8,8000); Commit; 1、数据表创建语句 创建部门数据表: CREATE TABLE Department (dp_id number(8), dp_name varchar(20), Up_DepID number ); 插入演示数据: INSERT INTO Department VALUES(1,技术组,0); INSER