Advertisement
alisame

Untitled

Sep 29th, 2021
486
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- For desktop version
  2. DROP TABLE employees;
  3. CREATE TABLE employees(  
  4.   TabNum   INT PRIMARY KEY,
  5.   DepNo    INT,    
  6.   EName    VARCHAR(40),  
  7.   post     VARCHAR(40),  
  8.   salary   INT,
  9.   born     DATE,  
  10.   phone    VARCHAR (40)  
  11. );
  12. INSERT INTO employees VALUES(988, 1, 'John Smith', 'Head of Department', 48500, '01-02-1970', '115-26-12');
  13. INSERT INTO employees VALUES(909, 1, ' Bruce Robertson', 'Lead Programmer', 48500, '20-10-1981', '115-91-19');
  14. INSERT INTO employees VALUES(829, 1, ' Curtis Cook', 'Economist', 43500, '03-10-1978','115-26-12' );
  15. INSERT INTO employees VALUES(819, 1, ' Carl Murphy', 'Economist', 43500, '13-11-1985','115-91-19' );
  16. INSERT INTO employees VALUES(100, 2, ' Claudia Sinclair', 'Programmer', 46500, '16-10-1982', NULL);
  17. INSERT INTO employees VALUES(110, 2, ' Constance London', 'Accountant', 42880, '22-05-1975','115-46-32' );
  18. INSERT INTO employees VALUES(023, 2, ' Daisy Nail', 'Chief Accountant', 59240, '24-11-1954','114-24-55' );
  19. INSERT INTO employees VALUES(130, 2, ' Dexter Round', 'Accountant', 42880, '1-07-1979','115-46-32');
  20. INSERT INTO employees VALUES(034, 3, ' Deborah Waite', 'Clerk', 32000, '24-04-1988', NULL);
  21. INSERT INTO employees VALUES(002, 3, ' Douglas Fairy', 'Head of Department', 48500, '08-06-1948', '115-12-69' );
  22. INSERT INTO employees VALUES(056, 5, ' Richard Hardman', 'Director', 80000, '05-05-1968','115-33-44');
  23. INSERT INTO employees VALUES(087, 5, ' Wilma Leapman', 'Secretary', 35000, '16-09-1990','115-33-65');
  24. INSERT INTO employees VALUES(088, 5, ' Stacey Longman', 'Deputy Director', 70000, '18-04-1974','115-33-01' );
  25. SELECT * FROM employees;
  26.  
  27.  
  28. -- For Live SQL
  29. DROP TABLE employees;
  30. CREATE TABLE employees(  
  31.   TabNum   INT PRIMARY KEY,
  32.   DepNo    INT,    
  33.   EName    VARCHAR(40),  
  34.   post     VARCHAR(40),  
  35.   salary   INT,
  36.   born     DATE,  
  37.   phone    VARCHAR (40)  
  38. );
  39. INSERT INTO employees VALUES(988, 1, 'John Smith', 'Head of Department', 48500, '01-FEB-1970', '115-26-12');
  40. INSERT INTO employees VALUES(909, 1, ' Bruce Robertson', 'Lead Programmer', 48500, '20-OCT-1981', '115-91-19');
  41. INSERT INTO employees VALUES(829, 1, ' Curtis Cook', 'Economist', 43500, '03-OCT-1978','115-26-12' );
  42. INSERT INTO employees VALUES(819, 1, ' Carl Murphy', 'Economist', 43500, '13-NOV-1985','115-91-19' );
  43. INSERT INTO employees VALUES(100, 2, ' Claudia Sinclair', 'Programmer', 46500, '16-OCT-1982', NULL);
  44. INSERT INTO employees VALUES(110, 2, ' Constance London', 'Accountant', 42880, '22-MAY-1975','115-46-32' );
  45. INSERT INTO employees VALUES(023, 2, ' Daisy Nail', 'Chief Accountant', 59240, '24-NOV-1954','114-24-55' );
  46. INSERT INTO employees VALUES(130, 2, ' Dexter Round', 'Accountant', 42880, '1-JUL-1979','115-46-32');
  47. INSERT INTO employees VALUES(034, 3, ' Deborah Waite', 'Clerk', 32000, '24-APR-1988', NULL);
  48. INSERT INTO employees VALUES(002, 3, ' Douglas Fairy', 'Head of Department', 48500, '08-JUN-1948', '115-12-69' );
  49. INSERT INTO employees VALUES(056, 5, ' Richard Hardman', 'Director', 80000, '05-MAY-1968','115-33-44');
  50. INSERT INTO employees VALUES(087, 5, ' Wilma Leapman', 'Secretary', 35000, '16-SEP-1990','115-33-65');
  51. INSERT INTO employees VALUES(088, 5, ' Stacey Longman', 'Deputy Director', 70000, '18-APR-1974','115-33-01' );
  52. SELECT * FROM employees;
  53.  
Advertisement
RAW Paste Data Copied
Advertisement