الانتقال إلى المحتوى

اريد HR 9i script ؟

aiman_g

بواسطة aiman_g
في منتدى أوراكل العام - General Discussion

 مشاركة

Recommended Posts

aiman_g مستخدم متحمس

aiman_g

بتاريخ:
بتاريخ:

السلام عليكم و رحمة الله و بركاته رجاء من الاخوة الافاضل انا عوز ال HR 9i script انا قدرت احصل عليه بس فاضى انا عاوزه ببيانات داخله .. كان عندى و ضاع ياريت مساعده...

تم تعديل عنوان الموضوع ليدل على محتواه
اداره المنتدى

رابط هذا التعليق
شارك
  • بعد 2 أسابيع...
Debug_b!bo مستخدم بارع

Debug_b!bo

بتاريخ:
بتاريخ: (معدل)

look brother
execute this script on the hr schema
(contains only data so your all tables must be created all)
Best regards
:)
i tried to atach the script and i could not so the commands is:
"INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'AR', 'Argentina', 2);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'AU', 'Australia', 3);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'BE', 'Belgium', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'BR', 'Brazil', 2);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'CA', 'Canada', 2);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'CH', 'Switzerland', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'CN', 'China', 3);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'DE', 'Germany', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'DK', 'Denmark', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'EG', 'Egypt', 4);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'FR', 'France', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'HK', 'HongKong', 3);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'IL', 'Israel', 4);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'IN', 'India', 3);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'IT', 'Italy', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'JP', 'Japan', 3);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'KW', 'Kuwait', 4);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'MX', 'Mexico', 2);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'NG', 'Nigeria', 4);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'NL', 'Netherlands', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'SG', 'Singapore', 3);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'UK', 'United Kingdom', 1);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'US', 'United States of America', 2);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'ZM', 'Zambia', 4);
INSERT INTO COUNTRIES ( COUNTRY_ID, COUNTRY_NAME, REGION_ID ) VALUES (
'ZW', 'Zimbabwe', 4);
commit;

INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
10, 'Administration', 200, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
20, 'Marketing', 201, 1800);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
30, 'Purchasing', 114, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
40, 'Human Resources', 203, 2400);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
50, 'Shipping', 121, 1500);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
60, 'IT', 103, 1400);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
70, 'Public Relations', 204, 2700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
80, 'Sales', 145, 2500);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
90, 'Executive', 100, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
100, 'Finance', 108, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
110, 'Accounting', 205, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
120, 'Treasury', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
130, 'Corporate Tax', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
140, 'Control And Credit', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
150, 'Shareholder Services', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
160, 'Benefits', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
170, 'Manufacturing', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
180, 'Construction', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
190, 'Contracting', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
200, 'Operations', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
210, 'IT Support', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
220, 'NOC', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
230, 'IT Helpdesk', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
240, 'Government Sales', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
250, 'Retail Sales', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
260, 'Recruiting', NULL, 1700);
INSERT INTO DEPARTMENTS ( DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,
LOCATION_ID ) VALUES (
270, 'Payroll', NULL, 1700);
commit;

INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
100, 'Steven', 'King', 'SKING', '515.123.4567', TO_Date( '06/17/1987 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'AD_PRES', 24000, NULL, NULL, 90);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
101, 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568', TO_Date( '09/21/1989 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'AD_VP', 17000, NULL, 100, 90);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
102, 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569', TO_Date( '01/13/1993 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'AD_VP', 17000, NULL, 100, 90);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
103, 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567', TO_Date( '01/03/1990 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'IT_PROG', 9000, NULL, 102, 60);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
104, 'Bruce', 'Ernst', 'BERNST', '590.423.4568', TO_Date( '05/21/1991 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'IT_PROG', 6000, NULL, 103, 60);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
105, 'David', 'Austin', 'DAUSTIN', '590.423.4569', TO_Date( '06/25/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'IT_PROG', 4800, NULL, 103, 60);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
106, 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560', TO_Date( '02/05/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'IT_PROG', 4800, NULL, 103, 60);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
107, 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567', TO_Date( '02/07/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'IT_PROG', 4200, NULL, 103, 60);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
108, 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569', TO_Date( '08/17/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'FI_MGR', 12000, NULL, 101, 100);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
109, 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169', TO_Date( '08/16/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'FI_ACCOUNT', 9000, NULL, 108, 100);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
110, 'John', 'Chen', 'JCHEN', '515.124.4269', TO_Date( '09/28/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'FI_ACCOUNT', 8200, NULL, 108, 100);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
111, 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369', TO_Date( '09/30/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'FI_ACCOUNT', 7700, NULL, 108, 100);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
112, 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469', TO_Date( '03/07/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'FI_ACCOUNT', 7800, NULL, 108, 100);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
113, 'Luis', 'Popp', 'LPOPP', '515.124.4567', TO_Date( '12/07/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'FI_ACCOUNT', 6900, NULL, 108, 100);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
114, 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561', TO_Date( '12/07/1994 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'PU_MAN', 11000, NULL, 100, 30);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
115, 'Alexander', 'Khoo', 'AKHOO', '515.127.4562', TO_Date( '05/18/1995 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'PU_CLERK', 3100, NULL, 114, 30);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
116, 'Shelli', 'Baida', 'SBAIDA', '515.127.4563', TO_Date( '12/24/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'PU_CLERK', 2900, NULL, 114, 30);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
117, 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564', TO_Date( '07/24/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'PU_CLERK', 2800, NULL, 114, 30);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
118, 'Guy', 'Himuro', 'GHIMURO', '515.127.4565', TO_Date( '11/15/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'PU_CLERK', 2600, NULL, 114, 30);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
119, 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566', TO_Date( '08/10/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'PU_CLERK', 2500, NULL, 114, 30);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
120, 'Matthew', 'Weiss', 'MWEISS', '650.123.1234', TO_Date( '07/18/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_MAN', 8000, NULL, 100, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
121, 'Adam', 'Fripp', 'AFRIPP', '650.123.2234', TO_Date( '04/10/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_MAN', 8200, NULL, 100, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
122, 'Payam', 'Kaufling', 'PKAUFLIN', '650.123.3234', TO_Date( '05/01/1995 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_MAN', 7900, NULL, 100, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
123, 'Shanta', 'Vollman', 'SVOLLMAN', '650.123.4234', TO_Date( '10/10/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_MAN', 6500, NULL, 100, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
124, 'Kevin', 'Mourgos', 'KMOURGOS', '650.123.5234', TO_Date( '11/16/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_MAN', 5800, NULL, 100, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
125, 'Julia', 'Nayer', 'JNAYER', '650.124.1214', TO_Date( '07/16/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3200, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
126, 'Irene', 'Mikkilineni', 'IMIKKILI', '650.124.1224', TO_Date( '09/28/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2700, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
127, 'James', 'Landry', 'JLANDRY', '650.124.1334', TO_Date( '01/14/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2400, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
128, 'Steven', 'Markle', 'SMARKLE', '650.124.1434', TO_Date( '03/08/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2200, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
129, 'Laura', 'Bissot', 'LBISSOT', '650.124.5234', TO_Date( '08/20/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3300, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
130, 'Mozhe', 'Atkinson', 'MATKINSO', '650.124.6234', TO_Date( '10/30/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2800, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
131, 'James', 'Marlow', 'JAMRLOW', '650.124.7234', TO_Date( '02/16/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2500, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
132, 'TJ', 'Olson', 'TJOLSON', '650.124.8234', TO_Date( '04/10/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2100, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
133, 'Jason', 'Mallin', 'JMALLIN', '650.127.1934', TO_Date( '06/14/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3300, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
134, 'Michael', 'Rogers', 'MROGERS', '650.127.1834', TO_Date( '08/26/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2900, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
135, 'Ki', 'Gee', 'KGEE', '650.127.1734', TO_Date( '12/12/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2400, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
136, 'Hazel', 'Philtanker', 'HPHILTAN', '650.127.1634', TO_Date( '02/06/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2200, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
137, 'Renske', 'Ladwig', 'RLADWIG', '650.121.1234', TO_Date( '07/14/1995 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3600, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
138, 'Stephen', 'Stiles', 'SSTILES', '650.121.2034', TO_Date( '10/26/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3200, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
139, 'John', 'Seo', 'JSEO', '650.121.2019', TO_Date( '02/12/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2700, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
140, 'Joshua', 'Patel', 'JPATEL', '650.121.1834', TO_Date( '04/06/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2500, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
141, 'Trenna', 'Rajs', 'TRAJS', '650.121.8009', TO_Date( '10/17/1995 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3500, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
142, 'Curtis', 'Davies', 'CDAVIES', '650.121.2994', TO_Date( '01/29/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 3100, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
143, 'Randall', 'Matos', 'RMATOS', '650.121.2874', TO_Date( '03/15/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2600, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
144, 'Peter', 'Vargas', 'PVARGAS', '650.121.2004', TO_Date( '07/09/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'ST_CLERK', 2500, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
145, 'John', 'Russell', 'JRUSSEL', '011.44.1344.429268', TO_Date( '10/01/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_MAN', 14000, 0.4, 100, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
146, 'Karen', 'Partners', 'KPARTNER', '011.44.1344.467268', TO_Date( '01/05/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_MAN', 13500, 0.3, 100, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
147, 'Alberto', 'Errazuriz', 'AERRAZUR', '011.44.1344.429278', TO_Date( '03/10/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_MAN', 12000, 0.3, 100, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
148, 'Gerald', 'Cambrault', 'GCAMBRAU', '011.44.1344.619268', TO_Date( '10/15/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_MAN', 11000, 0.3, 100, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
149, 'Eleni', 'Zlotkey', 'EZLOTKEY', '011.44.1344.429018', TO_Date( '01/29/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_MAN', 10500, 0.2, 100, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
150, 'Peter', 'Tucker', 'PTUCKER', '011.44.1344.129268', TO_Date( '01/30/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 10000, 0.3, 145, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
151, 'David', 'Bernstein', 'DBERNSTE', '011.44.1344.345268', TO_Date( '03/24/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 9500, 0.25, 145, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
152, 'Peter', 'Hall', 'PHALL', '011.44.1344.478968', TO_Date( '08/20/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 9000, 0.25, 145, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
153, 'Christopher', 'Olsen', 'COLSEN', '011.44.1344.498718', TO_Date( '03/30/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 8000, 0.2, 145, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
154, 'Nanette', 'Cambrault', 'NCAMBRAU', '011.44.1344.987668', TO_Date( '12/09/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7500, 0.2, 145, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
155, 'Oliver', 'Tuvault', 'OTUVAULT', '011.44.1344.486508', TO_Date( '11/23/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7000, 0.15, 145, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
156, 'Janette', 'King', 'JKING', '011.44.1345.429268', TO_Date( '01/30/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 10000, 0.35, 146, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
157, 'Patrick', 'Sully', 'PSULLY', '011.44.1345.929268', TO_Date( '03/04/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 9500, 0.35, 146, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
158, 'Allan', 'McEwen', 'AMCEWEN', '011.44.1345.829268', TO_Date( '08/01/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 9000, 0.35, 146, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
159, 'Lindsey', 'Smith', 'LSMITH', '011.44.1345.729268', TO_Date( '03/10/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 8000, 0.3, 146, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
160, 'Louise', 'Doran', 'LDORAN', '011.44.1345.629268', TO_Date( '12/15/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7500, 0.3, 146, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
161, 'Sarath', 'Sewall', 'SSEWALL', '011.44.1345.529268', TO_Date( '11/03/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7000, 0.25, 146, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
162, 'Clara', 'Vishney', 'CVISHNEY', '011.44.1346.129268', TO_Date( '11/11/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 10500, 0.25, 147, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
163, 'Danielle', 'Greene', 'DGREENE', '011.44.1346.229268', TO_Date( '03/19/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 9500, 0.15, 147, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
164, 'Mattea', 'Marvins', 'MMARVINS', '011.44.1346.329268', TO_Date( '01/24/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7200, 0.1, 147, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
165, 'David', 'Lee', 'DLEE', '011.44.1346.529268', TO_Date( '02/23/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 6800, 0.1, 147, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
166, 'Sundar', 'Ande', 'SANDE', '011.44.1346.629268', TO_Date( '03/24/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 6400, 0.1, 147, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
167, 'Amit', 'Banda', 'ABANDA', '011.44.1346.729268', TO_Date( '04/21/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 6200, 0.1, 147, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
168, 'Lisa', 'Ozer', 'LOZER', '011.44.1343.929268', TO_Date( '03/11/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 11500, 0.25, 148, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
169, 'Harrison', 'Bloom', 'HBLOOM', '011.44.1343.829268', TO_Date( '03/23/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 10000, 0.2, 148, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
170, 'Tayler', 'Fox', 'TFOX', '011.44.1343.729268', TO_Date( '01/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 9600, 0.2, 148, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
171, 'William', 'Smith', 'WSMITH', '011.44.1343.629268', TO_Date( '02/23/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7400, 0.15, 148, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
172, 'Elizabeth', 'Bates', 'EBATES', '011.44.1343.529268', TO_Date( '03/24/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7300, 0.15, 148, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
173, 'Sundita', 'Kumar', 'SKUMAR', '011.44.1343.329268', TO_Date( '04/21/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 6100, 0.1, 148, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
174, 'Ellen', 'Abel', 'EABEL', '011.44.1644.429267', TO_Date( '05/11/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 11000, 0.3, 149, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
175, 'Alyssa', 'Hutton', 'AHUTTON', '011.44.1644.429266', TO_Date( '03/19/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 8800, 0.25, 149, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
176, 'Jonathon', 'Taylor', 'JTAYLOR', '011.44.1644.429265', TO_Date( '03/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 8600, 0.2, 149, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
177, 'Jack', 'Livingston', 'JLIVINGS', '011.44.1644.429264', TO_Date( '04/23/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 8400, 0.2, 149, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
178, 'Kimberely', 'Grant', 'KGRANT', '011.44.1644.429263', TO_Date( '05/24/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 7000, 0.15, 149, NULL);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
179, 'Charles', 'Johnson', 'CJOHNSON', '011.44.1644.429262', TO_Date( '01/04/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SA_REP', 6200, 0.1, 149, 80);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
180, 'Winston', 'Taylor', 'WTAYLOR', '650.507.9876', TO_Date( '01/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3200, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
181, 'Jean', 'Fleaur', 'JFLEAUR', '650.507.9877', TO_Date( '02/23/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3100, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
182, 'Martha', 'Sullivan', 'MSULLIVA', '650.507.9878', TO_Date( '06/21/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2500, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
183, 'Girard', 'Geoni', 'GGEONI', '650.507.9879', TO_Date( '02/03/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2800, NULL, 120, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
184, 'Nandita', 'Sarchand', 'NSARCHAN', '650.509.1876', TO_Date( '01/27/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 4200, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
185, 'Alexis', 'Bull', 'ABULL', '650.509.2876', TO_Date( '02/20/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 4100, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
186, 'Julia', 'Dellinger', 'JDELLING', '650.509.3876', TO_Date( '06/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3400, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
187, 'Anthony', 'Cabrio', 'ACABRIO', '650.509.4876', TO_Date( '02/07/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3000, NULL, 121, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
188, 'Kelly', 'Chung', 'KCHUNG', '650.505.1876', TO_Date( '06/14/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3800, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
189, 'Jennifer', 'Dilly', 'JDILLY', '650.505.2876', TO_Date( '08/13/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3600, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
190, 'Timothy', 'Gates', 'TGATES', '650.505.3876', TO_Date( '07/11/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2900, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
191, 'Randall', 'Perkins', 'RPERKINS', '650.505.4876', TO_Date( '12/19/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2500, NULL, 122, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
192, 'Sarah', 'Bell', 'SBELL', '650.501.1876', TO_Date( '02/04/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 4000, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
193, 'Britney', 'Everett', 'BEVERETT', '650.501.2876', TO_Date( '03/03/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3900, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
194, 'Samuel', 'McCain', 'SMCCAIN', '650.501.3876', TO_Date( '07/01/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3200, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
195, 'Vance', 'Jones', 'VJONES', '650.501.4876', TO_Date( '03/17/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2800, NULL, 123, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
196, 'Alana', 'Walsh', 'AWALSH', '650.507.9811', TO_Date( '04/24/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3100, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
197, 'Kevin', 'Feeney', 'KFEENEY', '650.507.9822', TO_Date( '05/23/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 3000, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
198, 'Donald', 'OConnell', 'DOCONNEL', '650.507.9833', TO_Date( '06/21/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2600, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
199, 'Douglas', 'Grant', 'DGRANT', '650.507.9844', TO_Date( '01/13/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'SH_CLERK', 2600, NULL, 124, 50);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
200, 'Jennifer', 'Whalen', 'JWHALEN', '515.123.4444', TO_Date( '09/17/1987 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'AD_ASST', 4400, NULL, 101, 10);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
201, 'Michael', 'Hartstein', 'MHARTSTE', '515.123.5555', TO_Date( '02/17/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'MK_MAN', 13000, NULL, 100, 20);
INSERT INTO EMPLOYEES ( EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ) VALUES (
202, 'Pat', 'Fay', 'PFAY', '603.123.6666', TO_Date( '08/17/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM')
, 'MK_REP', 6000, NULL, 201, 20);
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, 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, '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 JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'AD_PRES', 'President', 20000, 40000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'AD_VP', 'Administration Vice President', 15000, 30000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'AD_ASST', 'Administration Assistant', 3000, 6000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'FI_MGR', 'Finance Manager', 8200, 16000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'FI_ACCOUNT', 'Accountant', 4200, 9000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'AC_MGR', 'Accounting Manager', 8200, 16000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'AC_ACCOUNT', 'Public Accountant', 4200, 9000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'SA_MAN', 'Sales Manager', 10000, 20000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'SA_REP', 'Sales Representative', 6000, 12000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'PU_MAN', 'Purchasing Manager', 8000, 15000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'PU_CLERK', 'Purchasing Clerk', 2500, 5500);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'ST_MAN', 'Stock Manager', 5500, 8500);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'ST_CLERK', 'Stock Clerk', 2000, 5000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'SH_CLERK', 'Shipping Clerk', 2500, 5500);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'IT_PROG', 'Programmer', 4000, 10000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'MK_MAN', 'Marketing Manager', 9000, 15000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'MK_REP', 'Marketing Representative', 4000, 9000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'HR_REP', 'Human Resources Representative', 4000, 9000);
INSERT INTO JOBS ( JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY ) VALUES (
'PR_REP', 'Public Relations Representative', 4500, 10500);
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);
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);
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;

INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1000, '1297 Via Cola di Rie', '00989', 'Roma', NULL, 'IT');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1100, '93091 Calle della Testa', '10934', 'Venice', NULL, 'IT');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1200, '2017 Shinjuku-ku', '1689', 'Tokyo', 'Tokyo Prefecture', 'JP');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1300, '9450 Kamiya-cho', '6823', 'Hiroshima', NULL, 'JP');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1400, '2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas', 'US');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1500, '2011 Interiors Blvd', '99236', 'South San Francisco', 'California', 'US');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1600, '2007 Zagora St', '50090', 'South Brunswick', 'New Jersey', 'US');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1700, '2004 Charade Rd', '98199', 'Seattle', 'Washington', 'US');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1800, '147 Spadina Ave', 'M5V 2L7', 'Toronto', 'Ontario', 'CA');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
1900, '6092 Boxwood St', 'YSW 9T2', 'Whitehorse', 'Yukon', 'CA');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2000, '40-5-12 Laogianggen', '190518', 'Beijing', NULL, 'CN');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2100, '1298 Vileparle (E)', '490231', 'Bombay', 'Maharashtra', 'IN');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2200, '12-98 Victoria Street', '2901', 'Sydney', 'New South Wales', 'AU');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2300, '198 Clementi North', '540198', 'Singapore', NULL, 'SG');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2400, '8204 Arthur St', NULL, 'London', NULL, 'UK');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2500, 'Magdalen Centre, The Oxford Science Park', 'OX9 9ZB', 'Oxford', 'Oxford', 'UK');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2600, '9702 Chester Road', '09629850293', 'Stretford', 'Manchester', 'UK');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2700, 'Schwanthalerstr. 7031', '80925', 'Munich', 'Bavaria', 'DE');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2800, 'Rua Frei Caneca 1360 ', '01307-002', 'Sao Paulo', 'Sao Paulo', 'BR');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
2900, '20 Rue des Corps-Saints', '1730', 'Geneva', 'Geneve', 'CH');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
3000, 'Murtenstrasse 921', '3095', 'Bern', 'BE', 'CH');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
3100, 'Pieter Breughelstraat 837', '3029SK', 'Utrecht', 'Utrecht', 'NL');
INSERT INTO LOCATIONS ( LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
COUNTRY_ID ) VALUES (
3200, 'Mariano Escobedo 9991', '11932', 'Mexico City', 'Distrito Federal,', 'MX');
commit;

INSERT INTO REGIONS ( REGION_ID, REGION_NAME ) VALUES (
1, 'Europe');
INSERT INTO REGIONS ( REGION_ID, REGION_NAME ) VALUES (
2, 'Americas');
INSERT INTO REGIONS ( REGION_ID, REGION_NAME ) VALUES (
3, 'Asia');
INSERT INTO REGIONS ( REGION_ID, REGION_NAME ) VALUES (
4, 'Middle East and Africa');
commit;
"

تم تعديل بواسطة Debug_b!bo
رابط هذا التعليق
شارك
aiman_g مستخدم متحمس

aiman_g

بتاريخ:
  • كاتب الموضوع
بتاريخ:

in the SQL* you can run this scripts by this command or script location

-connect to data base as your username & password then you can write it to run scripts

" @c:\hr\hr_cre.sql " then press ENTER you must write the true path in the SQL*



http://duke.htl-leonding.ac.at/~t.stuetz/d...rces/hr_cre.sql

http://duke.htl-leonding.ac.at/~t.stuetz/d...es/hr_popul.sql

http://duke.htl-leonding.ac.at/~t.stuetz/d...es/hr_comnt.sql

http://duke.htl-leonding.ac.at/~t.stuetz/d...ces/hr_code.sql

http://duke.htl-leonding.ac.at/~t.stuetz/d...rces/hr_idx.sql

رابط هذا التعليق
شارك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
 مشاركة
عودة لقائمة الموضوعات
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

  أوافق