home *** CD-ROM | disk | FTP | other *** search
/ WinWares 1 / WINWARES.ISO / database / gupta / emp.sql / emp.sql
Encoding:
Text File  |  1993-12-11  |  573 b   |  26 lines
  1. CREATE TABLE EMP (EMP_NAME CHAR(20), EMP_NO NUMBER, EMP_DOB DATETIME)
  2. /
  3. CREATE INDEX IX_EMP_NO ON EMP (EMP_NO)
  4. /
  5. INSERT INTO EMP VALUES (:1, :2, :3)
  6. \
  7. UMANG G,1001,11-01-84
  8. BRUCE S,2001,11-01-84
  9. DAVID I,2002,12-21-84
  10. DAVID R,2003,08-01-85
  11. DENNIS N,2004,09-01-85
  12. MIKE G,2005,04-01-86
  13. MIKE K,2006,04-01-86
  14. JEAN J,1002,07-01-86
  15. TRUDY R,1003,10-01-86
  16. STEVE B,2007,12-01-86
  17. EWA K,1004,02-01-87
  18. ED W,3001,04-01-87
  19. TOM H,1004,06-01-87
  20. MARK S,2008,07-01-87
  21. RICH H,1005,10-01-87
  22. LINDA H,1006,10-01-87
  23. /
  24. CREATE TABLE TMP (TMP_NO NUMBER, TMP_NAME CHAR(20))
  25. /
  26.