oracle脚步练习及答案.docVIP

SQL脚本： drop table emp; drop table dept; create table dept( deptno number(2) primary key, dname varchar2(10), loc varchar2(9) ); insert into dept values (10,ACCOUNTING,NEW YORK); insert into dept values (20,RESERCH,DALLAS); insert into dept values (30,SALES,CHICAGO); insert into dept values (40,OPERATIONS,BOSTON); commit; create table emp( empno number(4) primary key, ename varchar2(10), job varchar2(9), mgr number(4), hiredate date, sal number(7,2), comm number(7,2), deptno number(2) references dept(deptno) ); insert into emp values (7369,SMITH,CLER