INSERT INTO employees employeeid firstname lastname email phonenumber hiredate

Insert into employees employeeid firstname lastname

This preview shows page 67 - 72 out of 74 pages.

INSERT INTO employees ( employee_id , first_name , last_name , email , phone_number , hire_date , job_id , salary , commission_pct , manager_id , department_id ) VALUES ( 203 , 'Susan' , 'Mavris' , 'SMAVRIS' , '515.123.7777' , TO_DATE ('06/07/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'HR_REP' , 6500 , NULL , 101 , 40 ); INSERT INTO employees ( employee_id , first_name , last_name , email , phone_number , hire_date , job_id , salary , commission_pct
Image of page 67
, manager_id , department_id ) VALUES ( 204 , 'Hermann' , 'Baer' , 'HBAER' , '515.123.8888' , TO_DATE ('06/07/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'PR_REP' , 10000 , NULL , 101 , 70 ); INSERT INTO employees ( employee_id , first_name , last_name , email , phone_number , hire_date , job_id , salary , commission_pct , manager_id , department_id ) VALUES ( 205 , 'Shelley' , 'Higgins' , 'SHIGGINS' , '515.123.8080' , TO_DATE ('06/07/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'AC_MGR' , 12000 , NULL , 101 , 110 ); INSERT INTO employees ( employee_id , first_name , last_name , email , phone_number , hire_date , job_id , salary , commission_pct , manager_id , department_id ) VALUES ( 206
Image of page 68
, 'William' , 'Gietz' , 'WGIETZ' , '515.123.8181' , TO_DATE ('06/07/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'AC_ACCOUNT' , 8300 , NULL , 205 , 110 ); COMMIT; INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 102 , TO_DATE ('01/13/1993 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('07/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'IT_PROG' , 60 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 101 , TO_DATE ('09/21/1989 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('10/27/1993 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'AC_ACCOUNT' , 110 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 101 , TO_DATE ('10/28/1993 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('03/15/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'AC_MGR' , 110 );
Image of page 69
INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 201 , TO_DATE ('02/17/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('12/19/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'MK_REP' , 20 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 114 , TO_DATE ('03/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('12/31/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'ST_CLERK' , 50 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 122 , TO_DATE ('01/01/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('12/31/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'ST_CLERK' , 50 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 200 , TO_DATE ('09/17/1987 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('06/17/1993 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'AD_ASST' , 90 );
Image of page 70
INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 176 , TO_DATE ('03/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('12/31/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'SA_REP' , 80 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 176 , TO_DATE ('01/01/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('12/31/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'SA_MAN' , 80 ); INSERT INTO job_history ( employee_id , start_date , end_date , job_id , department_id ) VALUES ( 200 , TO_DATE ('07/01/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , TO_DATE ('12/31/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , 'AC_ACCOUNT' , 90 ); COMMIT; END; / CREATE UNIQUE INDEX dept_id_pk ON departments (department_id) / CREATE INDEX dept_location_ix ON departments (location_id) / CREATE UNIQUE INDEX emp_email_uk
Image of page 71
Image of page 72

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture