home *** CD-ROM | disk | FTP | other *** search
/ NeXTSTEP 3.2 (Developer) / NS_dev_3.2.iso / NextDeveloper / Examples / DatabaseKit / Models / OracleDemoScripts / EmpTable.sql < prev    next >
Encoding:
Text File  |  1993-05-24  |  1.7 KB  |  44 lines
  1. DROP TABLE EMP;
  2.  
  3. CREATE TABLE EMP
  4.        (EMPNO NUMBER(4) NOT NULL,
  5.         ENAME CHAR(10),
  6.         JOB CHAR(9),
  7.         RECORD_FILE VARCHAR(60) NOT NULL,
  8.         MGR NUMBER(4),
  9.         HIREDATE DATE,
  10.         SAL NUMBER(7,2),
  11.         COMM NUMBER(7,2),
  12.         DEPTNO NUMBER(2));
  13. CREATE UNIQUE INDEX EMP_INDEX ON EMP (EMPNO)
  14. INSERT INTO EMP VALUES
  15.         (7369,'SMITH','CLERK','/NextLibrary/Documentation/NextDev',7902,'17-DEC-80',800,NULL,20);
  16. INSERT INTO EMP VALUES
  17.         (7499,'ALLEN','SALESMAN','NextDeveloper/Headers/dbkit/customType.h',7698,'20-FEB-81',1600,300,30);
  18. INSERT INTO EMP VALUES
  19.         (7521,'WARD','SALESMAN','/tmp/console.log',7698,'22-FEB-81',1250,500,30);
  20. INSERT INTO EMP VALUES
  21.         (7566,'JONES','MANAGER','/tmp/console.log',7839,'2-APR-81',2975,NULL,20);
  22. INSERT INTO EMP VALUES
  23.         (7654,'MARTIN','SALESMAN',' ',7698,'28-SEP-81',1250,1400,30);
  24. INSERT INTO EMP VALUES
  25.         (7698,'BLAKE','MANAGER',' ',7839,'1-MAY-81',2850,NULL,30);
  26. INSERT INTO EMP VALUES
  27.         (7782,'CLARK','MANAGER',' ',7839,'9-JUN-81',2450,NULL,10);
  28. INSERT INTO EMP VALUES
  29.         (7788,'SCOTT','ANALYST',' ',7566,'09-DEC-82',3000,NULL,20);
  30. INSERT INTO EMP VALUES
  31.         (7839,'KING','PRESIDENT',' ',NULL,'17-NOV-81',5000,NULL,10);
  32. INSERT INTO EMP VALUES
  33.         (7844,'TURNER','SALESMAN',' ',7698,'8-SEP-81',1500,0,30);
  34. INSERT INTO EMP VALUES
  35.         (7876,'ADAMS','CLERK',' ',7788,'12-JAN-83',1100,NULL,20);
  36. INSERT INTO EMP VALUES
  37.         (7900,'JAMES','CLERK',' ',7698,'3-DEC-81',950,NULL,30);
  38. INSERT INTO EMP VALUES
  39.         (7902,'FORD','ANALYST',' ',7566,'3-DEC-81',3000,NULL,20);
  40. INSERT INTO EMP VALUES
  41.         (7934,'MILLER','CLERK',' ',7782,'23-JAN-82',1300,NULL,10);
  42.  
  43. COMMIT;
  44. EXIT;