home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a524 / 37.ddi / demo / load_emp.sql < prev    next >
Encoding:
Text File  |  1991-03-04  |  1.3 KB  |  51 lines
  1. rem
  2. rem $Header: load_emp.sql,v 6.1 90/02/16 18:40:21 nsalah Exp $ load_emp.sql Copyr (c) 1989 Oracle
  3. rem
  4. delete from emp
  5. /
  6. insert into emp values
  7.     (7369,'SMITH','CLERK',7902,'17-DEC-80',800,NULL,20)
  8. /
  9. insert into emp values
  10.     (7499,'ALLEN','SALESMAN',7698,'20-FEB-81',1600,300,30)
  11. /
  12. insert into emp values
  13.     (7521,'WARD','SALESMAN',7698,'22-FEB-81',1250,500,30)
  14. /
  15. insert into emp values
  16.     (7566,'JONES','MANAGER',7839,'2-APR-81',2975,NULL,20)
  17. /
  18. insert into emp values
  19.     (7654,'MARTIN','SALESMAN',7698,'28-SEP-81',1250,1400,20)
  20. /
  21. insert into emp values
  22.     (7698,'BLAKE','MANAGER',7839,'1-MAY-81',2850,NULL,30)
  23. /
  24. insert into emp values
  25.     (7782,'CLARK','SALESMAN',7839,'9-JUN-81',2450,400,10)
  26. /
  27. insert into emp values
  28.     (7788,'SCOTT','ANALYST',7566,SYSDATE-85,3000,NULL,20)
  29. /
  30. insert into emp values
  31.     (7839,'KING','PRESIDENT',NULL,'17-NOV-81',5000,NULL,10)
  32. /
  33. insert into emp values
  34.     (7844,'TURNER','SALESMAN',7698,'8-SEP-81',1500,450,30)
  35. /
  36. insert into emp values
  37.     (7876,'ADAMS','CLERK',7788,SYSDATE-51,1100,NULL,20)
  38. /
  39. insert into emp values
  40.     (7900,'JAMES','SALESMAN',7698,'3-DEC-81',950,550,30)
  41. /
  42. insert into emp values
  43.     (7902,'FORD','ANALYST',7566,'3-DEC-81',3000,NULL,20)
  44. /
  45. insert into emp values
  46.     (7934,'MILLER','SALESMAN',7782,'23-JAN-82',1300,100,10)
  47. /
  48. insert into emp values
  49.     (7698,'JACOBS','ANALYST',7782,'26-NOV-81',2870,NULL,10)
  50. /
  51.