1、创建
create table emp
(empno number(4) constraint EMP_pk primary key,
ename varchar2(9),
job varchar2(9),
mgr number(4),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2) constraint EMP_PK_DEPTNO references DEPT(deptno)
);
2、插入
insert into emp(empno,ename,job,mgr,hiredate,sal,deptno) values(7369,'smith','clerk',7902,'17-DEC-80',800,20);
insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7499,'allen','salseman',7698,'20-FEB-81',1600,300,30);
insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7521,'WARD','salseman',7698,'22-FEB-81',1250,500,30);
insert into emp(empno,ename,job,mgr,hiredate,sal,deptno) values(7566,'JONES','MANAGER',7839,'02-APR-81',2975,20);
insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7645,'MARTIN','SALESMAN',7698,'28-SEP-81',1250,1400,20);
insert into emp(empno,ename,job,mgr,hiredate,sal,deptno) values(7698,'BLACK','MANAGER',7839,'01-MAY-81',2850,20);
insert into emp(empno,ename,job,mgr,hiredate,sal,COMM,deptno) values(7844,'URNER','SALESMAN',7698,'08-SEP-81',1500,0,20);