sql

Citation preview

INSERT INTO EMPLOYEES VALUES (100,'steven','king','SKING','515.123.4567','17-061987','AD_PRES',24000,NULL,NULL,90); INSERT INTO EMPLOYEES VALUES (101,'Neena','Kochhar','NKOCHHAR','515.123.4568','2109-1989','AD_VP',17000,NULL,100,90); INSERT INTO EMPLOYEES VALUES (102,'Lex','De Haan','LDEHAAN','515.123.4589','13-011993','AD_VP',17000,NULL,100,90); INSERT INTO EMPLOYEES VALUES (103,'Alexander','Hunold','AHUNOLD','590.423.4567','03-011990','IT_PROG',9000,NULL,102,60); INSERT INTO EMPLOYEES VALUES (104,'Bruce','Ernct','BERNST','590.423.4568','21-051991','IT_PROG',6000,NULL,103,60); INSERT INTO EMPLOYEES VALUES (107,'Diana','Lorentz','DLORENTZ','590.423.5567','0702-1999','IT_PROG',4200,NULL,103,60); INSERT INTO EMPLOYEES VALUES (124,'Kevin','Mourgos','KMOURGOS','650.123.5234','1611-1999','ST_MAN',5800,NULL,100,50); INSERT INTO EMPLOYEES VALUES (141,'Trenna','Rajs','TRAJS','650.121.8009','17-101995','ST_CLERK',3500,NULL,124,50); INSERT INTO EMPLOYEES VALUES (142,'Curtis','Davies','CDAVIES','650.121.2994','2901-1997','ST_CLERK',3100,NULL,124,50); INSERT INTO EMPLOYEES VALUES (143,'Randall','Matos','RMATOS','650.121.2874','15-031998','ST_CLERK',2600,NULL,124,50); INSERT INTO EMPLOYEES VALUES (144,'Peter','Vargas','PVARGAS','650.121.2004','09-071998','ST_CLERK',2500,NULL,124,50); INSERT INTO EMPLOYEES VALUES (149,'Eleni','Zlatkey','EZLOTKEY','011.44.1344.429018','29-012000','SA_MAN',10500,.2,100,80); INSERT INTO EMPLOYEES VALUES (174,'Ellen','Abel','EABEL','011.44.1644.429267','1105-1996','SA_REP',11000,.3,149,80); INSERT INTO EMPLOYEES VALUES (176,'Jonathon','Taylor','JTAYLOR','011.44.1644.429265','24-031998','SA_REP',8600,.2,149,80); INSERT INTO EMPLOYEES VALUES (178,'Kimberely','Grant','KGRANT','011.44.1644.429263','24-051999','SA_REP',7000,.15,149,NULL); INSERT INTO EMPLOYEES VALUES (200,'Jennifer','Whalen','JWHALEN','515.123.4444','1709-1987','AD_ASST',4400,NULL,101,10); INSERT INTO EMPLOYEES VALUES (201,'Michael','Hartstein','MHRTESTE','515.123.5555','17-021996','MK_MAN',13000,NULL,100,20); INSERT INTO EMPLOYEES VALUES (202,'Pat','Fay','PFAY','603.123.6666','17-081997','MK_REP',6000,NULL,201,20); INSERT INTO EMPLOYEES VALUES (205,'Shelley','Higgins','SHIGGINS','515.123.8080','07-061994','AC_MGR',12000,NULL,101,110); INSERT INTO EMPLOYEES VALUES (206,'William','Gietz','WGIETZ','515.123.8181','07-061994','AC_ACCOUNT',8300,NULL,205,110);

CREATE TABLE EMPLOYEES ( EMPLOYEE_ID NUMBER(6) NOT NULL, FIRST_NAME VARCHAR2(20), LAST_NAME VARCHAR2(25) NOT NULL, EMAIL VARCHAR2(25) NOT NULL, PHONE_NUMBER VARCHAR2(20), HIRE_DATE DATE NOT NULL, JOB_ID VARCHAR2(10), SALARY NUMBER(8,2), COMMISSION_PCT NUMBER(2,2), MANAGER_ID NUMBER(6), DEPARTMENT_ID NUMBER(4)) ; CREATE TABLE DEPARTMENTS ( DEPARTMENT_ID NUMBER(4) NOT NULL, DEPARTMENT_NAME VARCHAR2(30) NOT NULL, MANAGER_ID NUMBER(4), LOCATION_ID NUMBER(4));

INSERT INTO EMPLOYEES VALUES (100,'steven','king','SKING','515.123.4567','17-061987','AD_PRES',24000,NULL,NULL,90); INSERT INTO EMPLOYEES VALUES (101,'Neena','Kochhar','NKOCHHAR','515.123.4568','2109-1989','AD_VP',17000,NULL,100,90); INSERT INTO EMPLOYEES VALUES (102,'Lex','De Haan','LDEHAAN','515.123.4589','13-011993','AD_VP',17000,NULL,100,90); INSERT INTO EMPLOYEES VALUES (103,'Alexander','Hunold','AHUNOLD','590.423.4567','03-011990','IT_PROG',9000,NULL,102,60); INSERT INTO EMPLOYEES VALUES (104,'Bruce','Ernct','BERNST','590.423.4568','21-051991','IT_PROG',6000,NULL,103,60); INSERT INTO EMPLOYEES VALUES (107,'Diana','Lorentz','DLORENTZ','590.423.5567','0702-1999','IT_PROG',4200,NULL,103,60); INSERT INTO EMPLOYEES VALUES (124,'Kevin','Mourgos','KMOURGOS','650.123.5234','1611-1999','ST_MAN',5800,NULL,100,50); INSERT INTO EMPLOYEES VALUES (141,'Trenna','Rajs','TRAJS','650.121.8009','17-101995','ST_CLERK',3500,NULL,124,50); INSERT INTO EMPLOYEES VALUES (142,'Curtis','Davies','CDAVIES','650.121.2994','2901-1997','ST_CLERK',3100,NULL,124,50); INSERT INTO EMPLOYEES VALUES (143,'Randall','Matos','RMATOS','650.121.2874','15-031998','ST_CLERK',2600,NULL,124,50); INSERT INTO EMPLOYEES VALUES (144,'Peter','Vargas','PVARGAS','