data_insert.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 25 行

drop table sm_emp cascade constraint;
CREATE table sm_emp
(EmpID CHAR(10) PRIMARY KEY,
Name   VARCHAR2(10),
salary NUMBER(8,2),
TelNo  CHAR(8));

INSERT INTO sm_emp VALUES('0000000001','张飞',100000,'62613546');
INSERT INTO sm_emp VALUES('0000000002','关羽',100000,'62613546');
INSERT INTO sm_emp VALUES('0000000003','刘备',100000,'62613546');
INSERT INTO sm_emp VALUES('0000000007','007',1000,'62634546');
COMMIT;

drop table sm_emp_sex;

create table sm_emp_sex
(EmpID char(10) primary key,
Name   varchar2(10),
salary number(8,2),
TelNo  char(8),
sex  char(2));

INSERT INTO sm_emp_sex VALUES('0000000001','张飞',100000,'62613546','男');