【文件属性】:
文件名称:数据表创建语句-SQL语句培训文档
文件大小:539KB
文件格式:PPT
更新时间:2021-04-25 22:09:46
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;
*