CREATE TABLE EMP ( ID NUMBER(6), LAST_NAME VARCHAR2(25 BYTE) NOT NULL, SALARY NUMBER(8,2), DEPT_ID NUMBER(7), COMMISSION NUMBER(2,2) ); CREATE UNIQUE INDEX MY_EMP_ID_PK ON EMP (ID); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (1, 'A', 24000, 10, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (5, 'E', 17000, 20, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (102, 'De Haan', 17000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (103, 'Hunold', 9000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (104, 'Ernst', 6000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (105, 'Austin', 4800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (106, 'Pataballa', 4800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (107, 'Lorentz', 4200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (108, 'Greenberg', 12000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (6, 'F', 9000, 20, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (110, 'Chen', 8200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (111, 'Sciarra', 7700, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (112, 'Urman', 7800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (113, 'Popp', 6900, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (114, 'Raphaely', 11000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (115, 'Khoo', 3100, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (116, 'Baida', 2900, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (117, 'Tobias', 2800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (118, 'Himuro', 2600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (119, 'Colmenares', 2500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (120, 'Weiss', 8000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (121, 'Fripp', 8200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (122, 'Kaufling', 7900, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (123, 'Vollman', 6500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (124, 'Mourgos', 5800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (125, 'Nayer', 3200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (7, 'G', 9000, 20, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (127, 'Landry', 2400, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (128, 'Markle', 2200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (129, 'Bissot', 3300, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (130, 'Atkinson', 2800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (131, 'Marlow', 2500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (132, 'Olson', 2100, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (133, 'Mallin', 3300, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (134, 'Rogers', 2900, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (135, 'Gee', 2400, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (136, 'Philtanker', 2200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (137, 'Ladwig', 3600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (138, 'Stiles', 3200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (139, 'Seo', 2700, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (140, 'Patel', 2500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (141, 'Rajs', 3500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (8, 'H', 2900, 20, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (143, 'Matos', 2600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (144, 'Vargas', 2500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (145, 'Russell', 14000, 70, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (146, 'Partners', 13500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (147, 'Errazuriz', 12000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (148, 'Cambrault', 11000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (149, 'Zlotkey', 10500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (150, 'Tucker', 10000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (151, 'Bernstein', 9500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (152, 'Hall', 9000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (9, 'I', 8000, 20, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (154, 'Cambrault', 7500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (155, 'Tuvault', 7000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (156, 'King', 10000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (157, 'Sully', 9500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (158, 'McEwen', 9000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (159, 'Smith', 8000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (160, 'Doran', 7500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (161, 'Sewall', 7000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (162, 'Vishney', 10500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (163, 'Greene', 9500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (164, 'Marvins', 7200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (165, 'Lee', 6800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (166, 'Ande', 6400, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (167, 'Banda', 6200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (168, 'Ozer', 11500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (169, 'Bloom', 10000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (170, 'Fox', 9600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (2, 'B', 7400, 10, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (3, 'C', 7300, 10, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (4, 'D', 6100, 10, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (174, 'Abel', 11000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (175, 'Hutton', 8800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (176, 'Taylor', 8600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (177, 'Livingston', 8400, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (178, 'Grant', 7000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (179, 'Johnson', 6200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (180, 'Taylor', 3200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (181, 'Fleaur', 3100, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (182, 'Sullivan', 2500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (183, 'Geoni', 2800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (184, 'Sarchand', 4200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (185, 'Bull', 4100, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (186, 'Dellinger', 3400, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (187, 'Cabrio', 3000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (188, 'Chung', 3800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (189, 'Dilly', 3600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (190, 'Gates', 2900, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (191, 'Perkins', 2500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (192, 'Bell', 4000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (193, 'Everett', 3900, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (194, 'McCain', 3200, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (195, 'Jones', 2800, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (196, 'Walsh', 3100, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (197, 'Feeney', 3000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (198, 'OConnell', 2600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (199, 'Grant', 2600, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (200, 'Whalen', 4400, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (201, 'Hartstein', 13000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (202, 'Fay', 6000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (203, 'Mavris', 6500, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (204, 'Baer', 10000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (205, 'Higgins', 12000, NULL, NULL); Insert into EMP (ID, LAST_NAME, SALARY, DEPT_ID, COMMISSION) Values (206, 'Gietz', 8300, NULL, NULL); COMMIT; CREATE TABLE EMP_TRANSFERRED ( EMPID NUMBER, TRANSFER_DATE DATE ); CREATE INDEX EMP_TRANSFERRED_INDX01 ON EMP_TRANSFERRED (EMPID); Insert into EMP_TRANSFERRED (EMPID, TRANSFER_DATE) Values (113, TO_DATE('08/20/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT; CREATE TABLE EMP_INACTIVE ( EMPID NUMBER, INACTIVE_DATE DATE ); CREATE INDEX EMP_INACTIVE_INDX01 ON EMP_INACTIVE (EMPID); Insert into EMP_INACTIVE (EMPID, INACTIVE_DATE) Values (105, TO_DATE('08/01/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS')); COMMIT;