create table DEPT@H_301_1@
(@H_301_1@
DEPTNO number(2) not null,@H_301_1@
DNAME varchar(14),@H_301_1@
LOC varchar(13)@H_301_1@
)@H_301_1@
;@H_301_1@
alter table DEPT@H_301_1@
add constraint PK_DEPT primary key (DEPTNO);@H_301_1@
@H_301_1@
create table EMP@H_301_1@
(@H_301_1@
EMPNO number(4) not null,@H_301_1@
ENAME varchar(10),@H_301_1@
JOB varchar(9),@H_301_1@
MGR number(4),@H_301_1@
HIREDATE date,@H_301_1@
SAL number(7 ),@H_301_1@
COMM number(7 ),@H_301_1@
DEPTNO number(2)@H_301_1@
)@H_301_1@
;@H_301_1@
alter table EMP@H_301_1@
add constraint PK_EMP primary key (EMPNO);@H_301_1@
alter table EMP@H_301_1@
add constraint FK_DEPTNO foreign key (DEPTNO)@H_301_1@
references DEPT (DEPTNO);@H_301_1@
@H_301_1@
insert into DEPT (DEPTNO,DNAME,LOC)@H_301_1@
values (10,'ACCOUNTING','NEW YORK');@H_301_1@
insert into DEPT (DEPTNO,LOC)@H_301_1@
values (20,'RESEARCH','DALLAS');@H_301_1@
insert into DEPT (DEPTNO,LOC)@H_301_1@
values (30,'SALES','CHICAGO');@H_301_1@
insert into DEPT (DEPTNO,LOC)@H_301_1@
values (40,'OPERATIONS','BOSTON');@H_301_1@
commit;@H_301_1@
@H_301_1@
insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)@H_301_1@
values (7369,'SMITH','CLERK',7902,to_date('1980-12-17','YYYY-MM-DD'),800,null,20);@H_301_1@
insert into EMP (EMPNO,DEPTNO)@H_301_1@
values (7499,'ALLEN','SALESMAN',7698,to_date('1981-02-20',1600,300,30);@H_301_1@
insert into EMP (EMPNO,DEPTNO)@H_301_1@
values (7521,'WARD',to_date('1981-02-22',1250,500,DEPTNO)@H_301_1@
values (7566,'JONES','MANAGER',7839,to_date('1981-04-02',2975,DEPTNO)@H_301_1@
values (7654,'MARTIN',to_date('1981-09-28',1400,DEPTNO)@H_301_1@
values (7698,'BLAKE',to_date('1981-05-01',2850,DEPTNO)@H_301_1@
values (7782,'CLARK',to_date('1981-06-09',2450,10);@H_301_1@
insert into EMP (EMPNO,DEPTNO)@H_301_1@
values (7788,'SCOTT','ANALYST',7566,to_date('1987-04-19',3000,DEPTNO)@H_301_1@
values (7839,'KING','PRESIDENT',to_date('1981-11-17',5000,DEPTNO)@H_301_1@
values (7844,'TURNER',to_date('1981-09-08',1500,DEPTNO)@H_301_1@
values (7876,'ADAMS',7788,to_date('1987-05-23',1100,DEPTNO)@H_301_1@
values (7900,'JAMES',to_date('1981-12-03',950,DEPTNO)@H_301_1@
values (7902,'FORD',to_date('1981-12-02',DEPTNO)@H_301_1@
values (7934,'MILLER',7782,to_date('1982-01-23',1300,10);@H_301_1@
commit;@H_301_1@
@H_301_1@
来自：http://blog.sina.com.cn/s/blog_6d76c7e20102v081.html@H_301_1@
