数据表创建语句-SQL语句培训文档

【文件属性】：

文件名称：数据表创建语句-SQL语句培训文档

文件大小：539KB

文件格式：PPT

更新时间：2024-05-15 15:56:26

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; *