美河学习在线 www.eimhe.com
3
17 (10,'ACCOUNTING','NEW YORK');
18 INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');
19 INSERT INTO DEPT VALUES
20 (30,'SALES','CHICAGO');
21 INSERT INTO DEPT VALUES
22 (40,'OPERATIONS','BOSTON');
23 INSERT INTO EMP VALUES
24 (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-
mm-yyyy'),800,NULL,20);
25 INSERT INTO EMP VALUES
26 (7499,'ALLEN','SALESMAN',7698,to_date('20-2-
1981','dd-mm-yyyy'),1600,300,30);
27 INSERT INTO EMP VALUES
28 (7521,'WARD','SALESMAN',7698,to_date('22-2-
1981','dd-mm-yyyy'),1250,500,30);
29 INSERT INTO EMP VALUES
30 (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-
mm-yyyy'),2975,NULL,20);
31 INSERT INTO EMP VALUES
32 (7654,'MARTIN','SALESMAN',7698,to_date('28-9-
1981','dd-mm-yyyy'),1250,1400,30);
33 INSERT INTO EMP VALUES
34 (7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-
mm-yyyy'),2850,NULL,30);
35 INSERT INTO EMP VALUES
36 (7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-
mm-yyyy'),2450,NULL,10);
37 INSERT INTO EMP VALUES
38 (7788,'SCOTT','ANALYST',7566,to_date('13-JUL-
87','dd-mm-rr')-85,3000,NULL,20);
39 INSERT INTO EMP VALUES
40 (7839,'KING','PRESIDENT',NULL,to_date('17-11-
1981','dd-mm-yyyy'),5000,NULL,10);
41 INSERT INTO EMP VALUES
评论0
最新资源