home *** CD-ROM | disk | FTP | other *** search
/ PC World Komputer 1996 February / PCWK0296.iso / po7_win / object10 / demoemp.sql < prev    next >
Text File  |  1994-08-24  |  2KB  |  18 lines
  1. Drop table emp2;
  2. Create table emp2( EMPNO NUMBER(4) NOT NULL,ENAME VARCHAR2(10),JOB VARCHAR2(9),MGR NUMBER(4),HIREDATE DATE,SAL NUMBER(7,2),COMM NUMBER(7,2),DEPTNO NUMBER(2) NOT NULL,VACATION NUMBER,HOBBY VARCHAR2(15) );
  3. Insert into emp2 values (7369,'SMITH','CLERK',NULL,'17-DEC-80',2230,1581,20,0,'Windsurfing');
  4. Insert into emp2 values (7990,'JOHNSON','SALESMAN',7698,'20-FEB-81',1600,380,30,1,'Fishing');
  5. Insert into emp2 values (7521,'WARD','SALESMAN',7698,'22-FEB-81',1250,500,30,0,'Swimming');
  6. Insert into emp2 values (7566,'JONES','MANAGER',7839,'3-DEC-81',2975,NULL,20,1,'Shopping');
  7. Insert into emp2 values (7654,'MARTIN','SALESMAN',7698,'17-NOV-81',1250,130,30,1,'Fishing');
  8. Insert into emp2 values (7698,'BLAKE','MANAGER',7839,'1-MAY-81',2850,NULL,30,0,'Bowling');
  9. Insert into emp2 values (7782,'CLARK','MANAGER',7839,'9-JUN-81',2450,NULL,10,1,NULL);
  10. Insert into emp2 values (7788,'SCOTT','ANALYST',7566,'22-FEB-81',3000,NULL,20,1,'Swimming');
  11. Insert into emp2 values (7839,'KING','PRESIDENT',NULL,'12-JAN-83',5000,2000,10,0,'Windsurfing');
  12. Insert into emp2 values (7844,'TURNER','SALESMAN',7698,'9-JUN-81',1500,0,30,0,NULL);
  13. Insert into emp2 values (7876,'ADAMS','CLERK',7788,'2-APR-81',1100,NULL,20,1,NULL);
  14. Insert into emp2 values (7900,'JAMES','CLERK',7698,'09-DEC-82',950,NULL,30,NULL,'Fishing');
  15. Insert into emp2 values (7902,'FORD','ANALYST',7566,'23-JAN-82',3000,NULL,20,1,'Swimming');
  16. Insert into emp2 values (7934,'MILLER','CLERK',7782,'2-APR-81',1300,NULL,10,0,'Shopping');
  17. commit;
  18.