create table DEPT

(

DEPTNO number(2) not null,

DNAME varchar(14),

LOC varchar(13)

)

;

alter table DEPT

add constraint PK_DEPT primary key (DEPTNO);

create table EMP

(

EMPNO number(4) not null,

ENAME varchar(10),

JOB varchar(9),

MGR number(4),

HIREDATE date,

SAL number(7 ),

COMM number(7 ),

DEPTNO number(2)

)

;

alter table EMP

add constraint PK_EMP primary key (EMPNO);

alter table EMP

add constraint FK_DEPTNO foreign key (DEPTNO)

references DEPT (DEPTNO);

insert into DEPT (DEPTNO,DNAME,LOC)

values (10,'ACCOUNTING','NEW YORK');

insert into DEPT (DEPTNO,LOC)

values (20,'RESEARCH','DALLAS');

insert into DEPT (DEPTNO,LOC)

values (30,'SALES','CHICAGO');

insert into DEPT (DEPTNO,LOC)

values (40,'OPERATIONS','BOSTON');

commit;

insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)

values (7369,'SMITH','CLERK',7902,to_date('1980-12-17','YYYY-MM-DD'),800,null,20);

insert into EMP (EMPNO,DEPTNO)

values (7499,'ALLEN','SALESMAN',7698,to_date('1981-02-20',1600,300,30);

insert into EMP (EMPNO,DEPTNO)

values (7521,'WARD',to_date('1981-02-22',1250,500,DEPTNO)

values (7566,'JONES','MANAGER',7839,to_date('1981-04-02',2975,DEPTNO)

values (7654,'MARTIN',to_date('1981-09-28',1400,DEPTNO)

values (7698,'BLAKE',to_date('1981-05-01',2850,DEPTNO)

values (7782,'CLARK',to_date('1981-06-09',2450,10);

insert into EMP (EMPNO,DEPTNO)

values (7788,'SCOTT','ANALYST',7566,to_date('1987-04-19',3000,DEPTNO)

values (7839,'KING','PRESIDENT',to_date('1981-11-17',5000,DEPTNO)

values (7844,'TURNER',to_date('1981-09-08',1500,DEPTNO)

values (7876,'ADAMS',7788,to_date('1987-05-23',1100,DEPTNO)

values (7900,'JAMES',to_date('1981-12-03',950,DEPTNO)

values (7902,'FORD',to_date('1981-12-02',DEPTNO)

values (7934,'MILLER',7782,to_date('1982-01-23',1300,10);

commit;

来自：http://blog.sina.com.cn/s/blog_6d76c7e20102v081.html