REM empLOYEE TABLE PROMPT PROMPT PROMPT *********************************************************************** PROMPT ******************* STARTING empLOYEE TABLE INSERTS ******************* PROMPT *********************************************************************** INSERT INTO emp VALUES( '000010' ,'CHRISTINE' ,'I' ,'HAAS' ,'A00' ,'3978' ,STR_TO_DATE('1965-01-01','%Y-%m-%d') ,'PRES' ,18 ,'F' ,STR_TO_DATE('1933-08-14','%Y-%m-%d') ,52750.00); INSERT INTO emp VALUES( '000020' ,'MICHAEL' ,'L' ,'THOMPSON' ,'B01' ,'3476' ,STR_TO_DATE('1973-10-10','%Y-%m-%d') ,'MANAGER' ,18 ,'M' ,STR_TO_DATE('1948-02-02','%Y-%m-%d') ,41250.00); INSERT INTO emp VALUES( '000030' ,'SALLY' ,'A' ,'KWAN' ,'C01' ,'4738' ,STR_TO_DATE('1975-04-05','%Y-%m-%d') ,'MANAGER' ,20 ,'F' ,STR_TO_DATE('1941-05-11','%Y-%m-%d') ,38250.00); INSERT INTO emp VALUES( '000050' ,'JOHN' ,'B' ,'GEYER' ,'E01' ,'6789' ,STR_TO_DATE('1949-08-17','%Y-%m-%d') ,'MANAGER' ,16 ,'M' ,STR_TO_DATE('1925-09-15','%Y-%m-%d') ,40175.00); INSERT INTO emp VALUES( '000060' ,'IRVING' ,'F' ,'STERN' ,'D11' ,'6423' ,STR_TO_DATE('1973-09-14','%Y-%m-%d') ,'MANAGER' ,16 ,'M' ,STR_TO_DATE('1945-07-07','%Y-%m-%d') ,32250.00); INSERT INTO emp VALUES( '000070' ,'EVA' ,'D' ,'PULASKI' ,'D21' ,'7831' ,STR_TO_DATE('1980-09-30','%Y-%m-%d') ,'MANAGER' ,16 ,'F' ,STR_TO_DATE('1953-05-26','%Y-%m-%d') ,36170.00); INSERT INTO emp VALUES( '000090' ,'EILEEN' ,'W' ,'HENDERSON' ,'E11' ,'5498' ,STR_TO_DATE('1970-08-15','%Y-%m-%d') ,'MANAGER' ,16 ,'F' ,STR_TO_DATE('1941-05-15','%Y-%m-%d') ,29750.00); INSERT INTO emp VALUES( '000100' ,'THEODORE' ,'Q' ,'SPENSER' ,'E21' ,'0972' ,STR_TO_DATE('1980-06-19','%Y-%m-%d') ,'MANAGER' ,14 ,'M' ,STR_TO_DATE('1956-12-18','%Y-%m-%d') ,26150.00); INSERT INTO emp VALUES( '000110' ,'VINCENZO' ,'G' ,'LUCCHESI' ,'A00' ,'3490' ,STR_TO_DATE('1958-05-16','%Y-%m-%d') ,'SALESREP' ,19 ,'M' ,STR_TO_DATE('1929-11-05','%Y-%m-%d') ,46500.00); INSERT INTO emp VALUES( '000120' ,'SEAN' ,' ' ,'O''CONNEL' ,'A00' ,'2167' ,STR_TO_DATE('1963-12-05','%Y-%m-%d') ,'CLERK' ,14 ,'M' ,STR_TO_DATE('1942-10-18','%Y-%m-%d') ,29250.00); INSERT INTO emp VALUES( '000130' ,'DOLORES' ,'M' ,'QUINTANA' ,'C01' ,'4578' ,STR_TO_DATE('1971-07-28','%Y-%m-%d') ,'ANALYST' ,16 ,'F' ,STR_TO_DATE('1925-09-15','%Y-%m-%d') ,23800.00); INSERT INTO emp VALUES( '000140' ,'HEATHER' ,'A' ,'NICHOLAS' ,'C01' ,'1793' ,STR_TO_DATE('1976-12-15','%Y-%m-%d') ,'ANALYST' ,18 ,'F' ,STR_TO_DATE('1946-01-19','%Y-%m-%d') ,28420.00); INSERT INTO emp VALUES( '000150' ,'BRUCE' ,' ' ,'ADAMSON' ,'D11' ,'4510' ,STR_TO_DATE('1972-02-12','%Y-%m-%d') ,'DESIGNER' ,16 ,'M' ,STR_TO_DATE('1947-05-17','%Y-%m-%d') ,25280.00); INSERT INTO emp VALUES( '000160' ,'ELIZABETH' ,'R' ,'PIANKA' ,'D11' ,'3782' ,STR_TO_DATE('1977-10-11','%Y-%m-%d') ,'DESIGNER' ,17 ,'F' ,STR_TO_DATE('1955-04-12','%Y-%m-%d') ,22250.00); INSERT INTO emp VALUES( '000170' ,'MASATOSHI' ,'J' ,'YOSHIMURA' ,'D11' ,'2890' ,STR_TO_DATE('1978-09-15','%Y-%m-%d') ,'DESIGNER' ,16 ,'M' ,STR_TO_DATE('1951-01-05','%Y-%m-%d') ,24680.00); INSERT INTO emp VALUES( '000180' ,'MARILYN' ,'S' ,'SCOUTTEN' ,'D11' ,'1682' ,STR_TO_DATE('1973-07-07','%Y-%m-%d') ,'DESIGNER' ,17 ,'F' ,STR_TO_DATE('1949-02-21','%Y-%m-%d') ,21340.00); INSERT INTO emp VALUES( '000190' ,'JAMES' ,'H' ,'WALKER' ,'D11' ,'2986' ,STR_TO_DATE('1974-07-26','%Y-%m-%d') ,'DESIGNER' ,16 ,'M' ,STR_TO_DATE('1952-06-25','%Y-%m-%d') ,20450.00); INSERT INTO emp VALUES( '000200' ,'DAVID' ,' ' ,'BROWN' ,'D11' ,'4501' ,STR_TO_DATE('1966-03-03','%Y-%m-%d') ,'DESIGNER' ,16 ,'M' ,STR_TO_DATE('1941-05-29','%Y-%m-%d') ,27740.00); INSERT INTO emp VALUES( '000210' ,'WILLIAM' ,'T' ,'JONES' ,'D11' ,'0942' ,STR_TO_DATE('1979-04-11','%Y-%m-%d') ,'DESIGNER' ,17 ,'M' ,STR_TO_DATE('1953-02-23','%Y-%m-%d') ,18270.00); INSERT INTO emp VALUES( '000220' ,'JENIFFER' ,'K' ,'LUTZ' ,'D11' ,'0672' ,STR_TO_DATE('1968-08-29','%Y-%m-%d') ,'DESIGNER' ,18 ,'F' ,STR_TO_DATE('1948-03-19','%Y-%m-%d') ,29840.00); INSERT INTO emp VALUES( '000230' ,'JAMES' ,'J' ,'JEFFERSON' ,'D21' ,'2094' ,STR_TO_DATE('1966-11-21','%Y-%m-%d') ,'CLERK' ,14 ,'M' ,STR_TO_DATE('1935-05-30','%Y-%m-%d') ,22180.00); INSERT INTO emp VALUES( '000240' ,'SALVATORE' ,'M' ,'MARINO' ,'D21' ,'3780' ,STR_TO_DATE('1979-12-05','%Y-%m-%d') ,'CLERK' ,17 ,'M' ,STR_TO_DATE('1954-03-31','%Y-%m-%d') ,28760.00); INSERT INTO emp VALUES( '000250' ,'DANIEL' ,'S' ,'SMITH' ,'D21' ,'0961' ,STR_TO_DATE('1969-10-30','%Y-%m-%d') ,'CLERK' ,15 ,'M' ,STR_TO_DATE('1939-11-12','%Y-%m-%d') ,19180.00); INSERT INTO emp VALUES( '000260' ,'SYBIL' ,'V' ,'JOHNSON' ,'D21' ,'8953' ,STR_TO_DATE('1975-09-11','%Y-%m-%d') ,'CLERK' ,16 ,'F' ,STR_TO_DATE('1936-10-05','%Y-%m-%d') ,17250.00); INSERT INTO emp VALUES( '000270' ,'MARIA' ,'L' ,'PEREZ' ,'D21' ,'9001' ,STR_TO_DATE('1980-09-30','%Y-%m-%d') ,'CLERK' ,15 ,'F' ,STR_TO_DATE('1953-05-26','%Y-%m-%d') ,27380.00); INSERT INTO emp VALUES( '000280' ,'ETHEL' ,'R' ,'SCHNEIDER' ,'E11' ,'8997' ,STR_TO_DATE('1967-03-24','%Y-%m-%d') ,'OPERATOR' ,17 ,'F' ,STR_TO_DATE('1936-03-28','%Y-%m-%d') ,26250.00); INSERT INTO emp VALUES( '000290' ,'JOHN' ,'R' ,'PARKER' ,'E11' ,'4502' ,STR_TO_DATE('1980-05-30','%Y-%m-%d') ,'OPERATOR' ,12 ,'M' ,STR_TO_DATE('1946-07-09','%Y-%m-%d') ,15340.00); INSERT INTO emp VALUES( '000300' ,'PHILIP' ,'X' ,'SMITH' ,'E11' ,'2095' ,STR_TO_DATE('1972-06-19','%Y-%m-%d') ,'OPERATOR' ,14 ,'M' ,STR_TO_DATE('1936-10-27','%Y-%m-%d') ,17750.00); INSERT INTO emp VALUES( '000310' ,'MAUDE' ,'F' ,'SETRIGHT' ,'E11' ,'3332' ,STR_TO_DATE('1964-09-12','%Y-%m-%d') ,'OPERATOR' ,12 ,'F' ,STR_TO_DATE('1931-04-21','%Y-%m-%d') ,15900.00); INSERT INTO emp VALUES( '000320' ,'RAMLAL' ,'V' ,'MEHTA' ,'E21' ,'9990' ,STR_TO_DATE('1965-07-07','%Y-%m-%d') ,'FIELDREP' ,16 ,'M' ,STR_TO_DATE('1932-08-11','%Y-%m-%d') ,19950.00); INSERT INTO emp VALUES( '000330' ,'WING' ,' ' ,'LEE' ,'E21' ,'2103' ,STR_TO_DATE('1976-02-23','%Y-%m-%d') ,'FIELDREP' ,14 ,'M' ,STR_TO_DATE('1941-07-18','%Y-%m-%d') ,25370.00); INSERT INTO emp VALUES( '000340' ,'JASON' ,'R' ,'GOUNOT' ,'E21' ,'5698' ,STR_TO_DATE('1947-05-05','%Y-%m-%d') ,'FIELDREP' ,16 ,'M' ,STR_TO_DATE('1926-05-17','%Y-%m-%d') ,23840.00); INSERT INTO emp VALUES( '200010' ,'DIAN' ,'J' ,'HE%mINGER' ,'A00' ,'3978' ,STR_TO_DATE('1965-01-01','%Y-%m-%d') ,'SALESREP' ,18 ,'F' ,STR_TO_DATE('1933-08-14','%Y-%m-%d') ,46500.00); INSERT INTO emp VALUES( '200120' ,'GREG' ,' ' ,'ORLANDO' ,'A00' ,'2167' ,STR_TO_DATE('1972-05-05','%Y-%m-%d') ,'CLERK' ,14 ,'M' ,STR_TO_DATE('1942-10-18','%Y-%m-%d') ,29250.00); INSERT INTO emp VALUES( '200140' ,'KIM' ,'N' ,'NATZ' ,'C01' ,'1793' ,STR_TO_DATE('1976-12-15','%Y-%m-%d') ,'ANALYST' ,18 ,'F' ,STR_TO_DATE('1946-01-19','%Y-%m-%d') ,28420.00); INSERT INTO emp VALUES( '200170' ,'KIYOSHI' ,' ' ,'YAMAMOTO' ,'D11' ,'2890' ,STR_TO_DATE('1978-09-15','%Y-%m-%d') ,'DESIGNER' ,16 ,'M' ,STR_TO_DATE('1951-01-05','%Y-%m-%d') ,24680.00); INSERT INTO emp VALUES( '200220' ,'REBA' ,'K' ,'JOHN' ,'D11' ,'0672' ,STR_TO_DATE('1968-08-29','%Y-%m-%d') ,'DESIGNER' ,18 ,'F' ,STR_TO_DATE('1948-03-19','%Y-%m-%d') ,29840.00); INSERT INTO emp VALUES( '200240' ,'ROBERT' ,'M' ,'MONTEVERDE' ,'D21' ,'3780' ,STR_TO_DATE('1979-12-05','%Y-%m-%d') ,'CLERK' ,17 ,'M' ,STR_TO_DATE('1954-03-31','%Y-%m-%d') ,28760.00); INSERT INTO emp VALUES( '200280' ,'EILEEN' ,'R' ,'SCHWARTZ' ,'E11' ,'8997' ,STR_TO_DATE('1967-03-24','%Y-%m-%d') ,'OPERATOR' ,17 ,'F' ,STR_TO_DATE('1936-03-28','%Y-%m-%d') ,26250.00); INSERT INTO emp VALUES( '200310' ,'MICHELLE' ,'F' ,'SPRINGER' ,'E11' ,'3332' ,STR_TO_DATE('1964-09-12','%Y-%m-%d') ,'OPERATOR' ,12 ,'F' ,STR_TO_DATE('1931-04-21','%Y-%m-%d') ,15900.00); INSERT INTO emp VALUES( '200330' ,'HELENA' ,' ' ,'WONG' ,'E21' ,'2103' ,STR_TO_DATE('1976-02-23','%Y-%m-%d') ,'FIELDREP' ,14 ,'F' ,STR_TO_DATE('1941-07-18','%Y-%m-%d') ,25370.00); INSERT INTO emp VALUES( '200340' ,'ROY' ,'R' ,'ALONZO' ,'E21' ,'5698' ,STR_TO_DATE('1947-05-05','%Y-%m-%d') ,'FIELDREP' ,16 ,'M' ,STR_TO_DATE('1926-05-17','%Y-%m-%d') ,23840.00); PROMPT *********************************************************************** PROMPT ******************** ENDING empLOYEE TABLE INSERTS ******************** PROMPT ***********************************************************************