gitsilence 的个人博客
Coding...
目录
Oracle数据库例题
Oracle数据库例题
平时课本的的例题和课后题.
导入需要用的数据
首先创建用户 zs
--------------------------------------------------------
-- 文件已创建 - 星期一-十月-28-2019
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Sequence DEPARTMENTS_SEQ
--------------------------------------------------------
CREATE SEQUENCE "ZS"."DEPARTMENTS_SEQ" MINVALUE 1 MAXVALUE 9990 INCREMENT BY 10 START WITH 280 NOCACHE NOORDER NOCYCLE NOPARTITION ;
--------------------------------------------------------
-- DDL for Sequence EMPLOYEES_SEQ
--------------------------------------------------------
CREATE SEQUENCE "ZS"."EMPLOYEES_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 207 NOCACHE NOORDER NOCYCLE NOPARTITION ;
--------------------------------------------------------
-- DDL for Sequence LOCATIONS_SEQ
--------------------------------------------------------
CREATE SEQUENCE "ZS"."LOCATIONS_SEQ" MINVALUE 1 MAXVALUE 9900 INCREMENT BY 100 START WITH 3300 NOCACHE NOORDER NOCYCLE NOPARTITION ;
--------------------------------------------------------
-- DDL for Table COUNTRIES
--------------------------------------------------------
CREATE TABLE "ZS"."COUNTRIES"
( "COUNTRY_ID" CHAR(2 BYTE),
"COUNTRY_NAME" VARCHAR2(40 BYTE),
"REGION_ID" NUMBER,
PRIMARY KEY ("COUNTRY_ID") ENABLE
) ORGANIZATION INDEX NOCOMPRESS PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS"
PCTTHRESHOLD 50;
--------------------------------------------------------
-- DDL for Table DEPARTMENTS
--------------------------------------------------------
CREATE TABLE "ZS"."DEPARTMENTS"
( "DEPARTMENT_ID" NUMBER(4,0),
"DEPARTMENT_NAME" VARCHAR2(30 BYTE),
"MANAGER_ID" NUMBER(6,0),
"LOCATION_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table DEPT_SALARY_STAT
--------------------------------------------------------
CREATE TABLE "ZS"."DEPT_SALARY_STAT"
( "DEPARTMENT_ID" NUMBER(20,0),
"MAX_SALAEY" NUMBER(20,0),
"MIN_SALARY" NUMBER(20,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMPLOYEES
--------------------------------------------------------
CREATE TABLE "ZS"."EMPLOYEES"
( "EMPLOYEE_ID" NUMBER(6,0),
"FIRST_NAME" VARCHAR2(20 BYTE),
"LAST_NAME" VARCHAR2(25 BYTE),
"EMAIL" VARCHAR2(25 BYTE),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"HIRE_DATE" DATE,
"JOB_ID" VARCHAR2(10 BYTE),
"SALARY" NUMBER(8,2),
"COMMISSION_PCT" NUMBER(2,2),
"MANAGER_ID" NUMBER(6,0),
"DEPARTMENT_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMP_10
--------------------------------------------------------
CREATE TABLE "ZS"."EMP_10"
( "EMPLOYEE_ID" NUMBER(6,0),
"FIRST_NAME" VARCHAR2(20 BYTE),
"LAST_NAME" VARCHAR2(25 BYTE),
"EMAIL" VARCHAR2(25 BYTE),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"HIRE_DATE" DATE,
"JOB_ID" VARCHAR2(10 BYTE),
"SALARY" NUMBER(8,2),
"COMMISSION_PCT" NUMBER(2,2),
"MANAGER_ID" NUMBER(6,0),
"DEPARTMENT_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMP_20
--------------------------------------------------------
CREATE TABLE "ZS"."EMP_20"
( "EMPLOYEE_ID" NUMBER(6,0),
"FIRST_NAME" VARCHAR2(20 BYTE),
"LAST_NAME" VARCHAR2(25 BYTE),
"EMAIL" VARCHAR2(25 BYTE),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"HIRE_DATE" DATE,
"JOB_ID" VARCHAR2(10 BYTE),
"SALARY" NUMBER(8,2),
"COMMISSION_PCT" NUMBER(2,2),
"MANAGER_ID" NUMBER(6,0),
"DEPARTMENT_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMP_30
--------------------------------------------------------
CREATE TABLE "ZS"."EMP_30"
( "EMPLOYEE_ID" NUMBER(6,0),
"FIRST_NAME" VARCHAR2(20 BYTE),
"LAST_NAME" VARCHAR2(25 BYTE),
"EMAIL" VARCHAR2(25 BYTE),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"HIRE_DATE" DATE,
"JOB_ID" VARCHAR2(10 BYTE),
"SALARY" NUMBER(8,2),
"COMMISSION_PCT" NUMBER(2,2),
"MANAGER_ID" NUMBER(6,0),
"DEPARTMENT_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMP_MGR
--------------------------------------------------------
CREATE TABLE "ZS"."EMP_MGR"
( "EMPLOYEE_ID" NUMBER(6,0),
"MANAGER_ID" NUMBER(6,0),
"SALARY" NUMBER(8,2)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMP_OTHER
--------------------------------------------------------
CREATE TABLE "ZS"."EMP_OTHER"
( "EMPLOYEE_ID" NUMBER(6,0),
"FIRST_NAME" VARCHAR2(20 BYTE),
"LAST_NAME" VARCHAR2(25 BYTE),
"EMAIL" VARCHAR2(25 BYTE),
"PHONE_NUMBER" VARCHAR2(20 BYTE),
"HIRE_DATE" DATE,
"JOB_ID" VARCHAR2(10 BYTE),
"SALARY" NUMBER(8,2),
"COMMISSION_PCT" NUMBER(2,2),
"MANAGER_ID" NUMBER(6,0),
"DEPARTMENT_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table EMP_SAL
--------------------------------------------------------
CREATE TABLE "ZS"."EMP_SAL"
( "EMPLOYEE_ID" NUMBER(6,0),
"HIRE_DATE" DATE,
"SALARY" NUMBER(8,2)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table JOBS
--------------------------------------------------------
CREATE TABLE "ZS"."JOBS"
( "JOB_ID" VARCHAR2(10 BYTE),
"JOB_TITLE" VARCHAR2(35 BYTE),
"MIN_SALARY" NUMBER(6,0),
"MAX_SALARY" NUMBER(6,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table JOB_HISTORY
--------------------------------------------------------
CREATE TABLE "ZS"."JOB_HISTORY"
( "EMPLOYEE_ID" NUMBER(6,0),
"START_DATE" DATE,
"END_DATE" DATE,
"JOB_ID" VARCHAR2(10 BYTE),
"DEPARTMENT_ID" NUMBER(4,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table LOCATIONS
--------------------------------------------------------
CREATE TABLE "ZS"."LOCATIONS"
( "LOCATION_ID" NUMBER(4,0),
"STREET_ADDRESS" VARCHAR2(40 BYTE),
"POSTAL_CODE" VARCHAR2(12 BYTE),
"CITY" VARCHAR2(30 BYTE),
"STATE_PROVINCE" VARCHAR2(25 BYTE),
"COUNTRY_ID" CHAR(2 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table REGIONS
--------------------------------------------------------
CREATE TABLE "ZS"."REGIONS"
( "REGION_ID" NUMBER,
"REGION_NAME" VARCHAR2(25 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table SAL_GRADES
--------------------------------------------------------
CREATE TABLE "ZS"."SAL_GRADES"
( "GRADE" NUMBER,
"MIN_SALARY" NUMBER(8,2),
"MAX_SALARY" NUMBER(8,2)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table SOURCE_EMP
--------------------------------------------------------
CREATE TABLE "ZS"."SOURCE_EMP"
( "EMPLOYEE_ID" NUMBER(20,0),
"LAST_NAME" VARCHAR2(20 BYTE),
"DEPARTMENT_ID" NUMBER(20,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table TARGET_EMP
--------------------------------------------------------
CREATE TABLE "ZS"."TARGET_EMP"
( "EMPLOYEE_ID" NUMBER(20,0),
"LAST_NAME" VARCHAR2(20 BYTE),
"DEPARTMENT_ID" NUMBER(20,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table USERS
--------------------------------------------------------
CREATE TABLE "ZS"."USERS"
( "USER_ID" NUMBER(2,0),
"USER_NAME" CHAR(20 BYTE),
"PASSWORD" VARCHAR2(20 BYTE)
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for View EMP_BASE_INFO_VIEW
--------------------------------------------------------
CREATE OR REPLACE FORCE EDITIONABLE VIEW "ZS"."EMP_BASE_INFO_VIEW" ("EMPNO", "FENAME", "LNAME", "SAL", "DEPTNO") AS
SELECT employee_id,first_name,
last_name,salary,department_id
FROM employees;
REM INSERTING into ZS.COUNTRIES
SET DEFINE OFF;
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('AR','Argentina',2);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('AU','Australia',3);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('BE','Belgium',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('BR','Brazil',2);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('CA','Canada',2);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('CH','Switzerland',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('CN','China',3);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('DE','Germany',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('DK','Den05k',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('EG','Egypt',4);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('FR','France',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('HK','HongKong',3);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('IL','Israel',4);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('IN','India',3);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('IT','Italy',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('JP','Japan',3);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('KW','Kuwait',4);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('MX','Mexico',2);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('NG','Nigeria',4);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('NL','Netherlands',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('SG','Singapore',3);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('UK','United Kingdom',1);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('US','United States of America',2);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('ZM','Zambia',4);
Insert into ZS.COUNTRIES (COUNTRY_ID,COUNTRY_NAME,REGION_ID) values ('ZW','Zimbabwe',4);
REM INSERTING into ZS.DEPARTMENTS
SET DEFINE OFF;
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (10,'Administration',201,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (20,'05keting',201,1800);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (30,'Purchasing',114,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (40,'Human Resources',203,2400);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (50,'Shipping',121,1500);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (60,'IT',103,1400);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (70,'Public Relations',204,2700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (80,'Sales',145,2500);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (90,'Executive',101,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (100,'Finance',108,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (110,'Accounting',205,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (120,'Treasury',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (130,'Corporate Tax',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (140,'Control And Credit',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (150,'Shareholder Services',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (160,'Benefits',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (170,'Manufacturing',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (180,'Construction',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (190,'Contracting',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (200,'Operations',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (210,'IT Support',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (220,'NOC',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (230,'IT Helpdesk',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (240,'Government Sales',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (250,'Retail Sales',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (260,'Recruiting',null,1700);
Insert into ZS.DEPARTMENTS (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) values (270,'Payroll',null,1700);
REM INSERTING into ZS.DEPT_SALARY_STAT
SET DEFINE OFF;
REM INSERTING into ZS.EMPLOYEES
SET DEFINE OFF;
Insert into ZS.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('17-1月 -87','DD-MON-RR'),'AD_PRES',24000,null,null,90);
Insert into ZS.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('21-9月 -89','DD-MON-RR'),'AD_VP',17000,null,100,90);
Insert into ZS.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('13-6月 -93','DD-MON-RR'),'AD_VP',17000,null,100,90);
Insert into ZS.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('03-6月 -90','DD-MON-RR'),'IT_PROG',9000,null,102,60);
Insert into ZS.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('21-5月 -91','DD-MON-RR'),'IT_PROG',6000,null,103,60);
Insert into ZS.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('25-1月 -97','DD-MON-RR'),'IT_PROG',4800,null,103,60);
Insert into ZS.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('05-11月-98','DD-MON-RR'),'IT_PROG',4800,null,103,60);
Insert into ZS.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('07-11月-99','DD-MON-RR'),'IT_PROG',4200,null,103,60);
Insert into ZS.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('17-8月 -94','DD-MON-RR'),'FI_MGR',12000,null,101,100);
Insert into ZS.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('16-8月 -94','DD-MON-RR'),'FI_ACCOUNT',9000,null,108,100);
Insert into ZS.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('28-9月 -97','DD-MON-RR'),'FI_ACCOUNT',8200,null,108,100);
Insert into ZS.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('30-9月 -97','DD-MON-RR'),'FI_ACCOUNT',7700,null,108,100);
Insert into ZS.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('07-5月 -98','DD-MON-RR'),'FI_ACCOUNT',7800,null,108,100);
Insert into ZS.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('07-12月-99','DD-MON-RR'),'FI_ACCOUNT',6900,null,108,100);
Insert into ZS.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('07-12月-94','DD-MON-RR'),'PU_MAN',11000,null,100,30);
Insert into ZS.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('18-5月 -95','DD-MON-RR'),'PU_CLERK',3100,null,114,30);
Insert into ZS.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('24-12月-97','DD-MON-RR'),'PU_CLERK',2900,null,114,30);
Insert into ZS.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('24-7月 -97','DD-MON-RR'),'PU_CLERK',2800,null,114,30);
Insert into ZS.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('15-11月-98','DD-MON-RR'),'PU_CLERK',2600,null,114,30);
Insert into ZS.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('10-8月 -99','DD-MON-RR'),'PU_CLERK',2500,null,114,30);
Insert into ZS.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('18-7月 -96','DD-MON-RR'),'ST_MAN',4450,null,100,50);
Insert into ZS.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('10-4月 -97','DD-MON-RR'),'ST_MAN',4450,null,100,50);
Insert into ZS.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('01-5月 -95','DD-MON-RR'),'ST_MAN',4450,null,100,50);
Insert into ZS.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月-97','DD-MON-RR'),'ST_MAN',4450,null,100,50);
Insert into ZS.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('16-11月-99','DD-MON-RR'),'ST_MAN',4450,null,100,50);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (125,'07ia','Nayer','JNAYER','650.124.1214',to_date('16-7月 -97','DD-MON-RR'),'ST_CLERK',4450,null,120,50);
Insert into ZS.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('28-9月 -98','DD-MON-RR'),'ST_CLERK',4450,null,120,50);
Insert into ZS.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('14-6月 -99','DD-MON-RR'),'ST_CLERK',4450,null,120,50);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (128,'Steven','05kle','S05KLE','650.124.1434',to_date('08-5月 -00','DD-MON-RR'),'ST_CLERK',4450,null,120,50);
Insert into ZS.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('20-8月 -97','DD-MON-RR'),'ST_CLERK',4450,null,121,50);
Insert into ZS.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('30-10月-97','DD-MON-RR'),'ST_CLERK',4450,null,121,50);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (131,'James','05low','JAMRLOW','650.124.7234',to_date('16-11月-97','DD-MON-RR'),'ST_CLERK',4450,null,121,50);
Insert into ZS.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('10-4月 -99','DD-MON-RR'),'ST_CLERK',4450,null,121,50);
Insert into ZS.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('14-1月 -96','DD-MON-RR'),'ST_CLERK',4450,null,122,50);
Insert into ZS.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('26-8月 -98','DD-MON-RR'),'ST_CLERK',4450,null,122,50);
Insert into ZS.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月-99','DD-MON-RR'),'ST_CLERK',4450,null,122,50);
Insert into ZS.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('06-11月-00','DD-MON-RR'),'ST_CLERK',4450,null,122,50);
Insert into ZS.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('14-7月 -95','DD-MON-RR'),'ST_CLERK',4450,null,123,50);
Insert into ZS.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('26-10月-97','DD-MON-RR'),'ST_CLERK',4450,null,123,50);
Insert into ZS.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('12-11月-98','DD-MON-RR'),'ST_CLERK',4450,null,123,50);
Insert into ZS.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('06-4月 -98','DD-MON-RR'),'ST_CLERK',4450,null,123,50);
Insert into ZS.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('17-10月-95','DD-MON-RR'),'ST_CLERK',4450,null,124,50);
Insert into ZS.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('29-6月 -97','DD-MON-RR'),'ST_CLERK',4450,null,124,50);
Insert into ZS.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('15-5月 -98','DD-MON-RR'),'ST_CLERK',4450,null,124,50);
Insert into ZS.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('09-7月 -98','DD-MON-RR'),'ST_CLERK',4450,null,124,50);
Insert into ZS.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('01-10月-96','DD-MON-RR'),'SA_MAN',14000,0.4,100,80);
Insert into ZS.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('05-6月 -97','DD-MON-RR'),'SA_MAN',13500,0.3,100,80);
Insert into ZS.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('10-5月 -97','DD-MON-RR'),'SA_MAN',12000,0.3,100,80);
Insert into ZS.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('15-10月-99','DD-MON-RR'),'SA_MAN',11000,0.3,100,80);
Insert into ZS.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('29-6月 -00','DD-MON-RR'),'SA_MAN',10500,0.2,100,80);
Insert into ZS.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('30-6月 -97','DD-MON-RR'),'SA_REP',10000,0.3,145,80);
Insert into ZS.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('24-5月 -97','DD-MON-RR'),'SA_REP',9500,0.25,145,80);
Insert into ZS.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('20-8月 -97','DD-MON-RR'),'SA_REP',9000,0.25,145,80);
Insert into ZS.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('30-5月 -98','DD-MON-RR'),'SA_REP',8000,0.2,145,80);
Insert into ZS.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('09-12月-98','DD-MON-RR'),'SA_REP',7500,0.2,145,80);
Insert into ZS.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('23-11月-99','DD-MON-RR'),'SA_REP',7000,0.15,145,80);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (156,'06ette','King','JKING','011.44.1345.429268',to_date('30-6月 -96','DD-MON-RR'),'SA_REP',10000,0.35,146,80);
Insert into ZS.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('04-5月 -96','DD-MON-RR'),'SA_REP',9500,0.35,146,80);
Insert into ZS.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('01-8月 -96','DD-MON-RR'),'SA_REP',9000,0.35,146,80);
Insert into ZS.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('10-5月 -97','DD-MON-RR'),'SA_REP',8000,0.3,146,80);
Insert into ZS.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('15-12月-97','DD-MON-RR'),'SA_REP',7500,0.3,146,80);
Insert into ZS.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('03-11月-98','DD-MON-RR'),'SA_REP',7000,0.25,146,80);
Insert into ZS.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月-97','DD-MON-RR'),'SA_REP',10500,0.25,147,80);
Insert into ZS.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('19-5月 -99','DD-MON-RR'),'SA_REP',9500,0.15,147,80);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (164,'Mattea','05vins','M05VINS','011.44.1346.329268',to_date('24-6月 -00','DD-MON-RR'),'SA_REP',7200,0.1,147,80);
Insert into ZS.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('23-11月-00','DD-MON-RR'),'SA_REP',6800,0.1,147,80);
Insert into ZS.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('24-5月 -00','DD-MON-RR'),'SA_REP',6400,0.1,147,80);
Insert into ZS.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('21-4月 -00','DD-MON-RR'),'SA_REP',6200,0.1,147,80);
Insert into ZS.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('11-5月 -97','DD-MON-RR'),'SA_REP',11500,0.25,148,80);
Insert into ZS.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('23-5月 -98','DD-MON-RR'),'SA_REP',10000,0.2,148,80);
Insert into ZS.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('24-6月 -98','DD-MON-RR'),'SA_REP',9600,0.2,148,80);
Insert into ZS.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('23-11月-99','DD-MON-RR'),'SA_REP',7400,0.15,148,80);
Insert into ZS.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('24-5月 -99','DD-MON-RR'),'SA_REP',7300,0.15,148,80);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (173,'Sundita','Ku05','SKU05','011.44.1343.329268',to_date('21-4月 -00','DD-MON-RR'),'SA_REP',6100,0.1,148,80);
Insert into ZS.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('11-5月 -96','DD-MON-RR'),'SA_REP',11000,0.3,149,80);
Insert into ZS.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('19-5月 -97','DD-MON-RR'),'SA_REP',8800,0.25,149,80);
Insert into ZS.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('24-5月 -98','DD-MON-RR'),'SA_REP',8600,0.2,149,80);
Insert into ZS.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('23-4月 -98','DD-MON-RR'),'SA_REP',8400,0.2,149,80);
Insert into ZS.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('24-5月 -99','DD-MON-RR'),'SA_REP',7000,0.15,149,20);
Insert into ZS.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('04-6月 -00','DD-MON-RR'),'SA_REP',6200,0.1,149,80);
Insert into ZS.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('24-6月 -98','DD-MON-RR'),'SH_CLERK',4450,null,120,50);
Insert into ZS.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('23-11月-98','DD-MON-RR'),'SH_CLERK',4450,null,120,50);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (182,'05tha','Sullivan','MSULLIVA','650.507.9878',to_date('21-1月 -99','DD-MON-RR'),'SH_CLERK',4450,null,120,50);
Insert into ZS.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('03-11月-00','DD-MON-RR'),'SH_CLERK',4450,null,120,50);
Insert into ZS.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('27-6月 -96','DD-MON-RR'),'SH_CLERK',4450,null,121,50);
Insert into ZS.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('20-11月-97','DD-MON-RR'),'SH_CLERK',4450,null,121,50);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (186,'07ia','Dellinger','JDELLING','650.509.3876',to_date('24-1月 -98','DD-MON-RR'),'SH_CLERK',4450,null,121,50);
Insert into ZS.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('07-11月-99','DD-MON-RR'),'SH_CLERK',4450,null,121,50);
Insert into ZS.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('14-1月 -97','DD-MON-RR'),'SH_CLERK',4450,null,122,50);
Insert into ZS.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('13-8月 -97','DD-MON-RR'),'SH_CLERK',4450,null,122,50);
Insert into ZS.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('11-7月 -98','DD-MON-RR'),'SH_CLERK',4450,null,122,50);
Insert into ZS.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('19-12月-99','DD-MON-RR'),'SH_CLERK',4450,null,122,50);
Insert into ZS.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('04-11月-96','DD-MON-RR'),'SH_CLERK',4450,null,123,50);
Insert into ZS.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-5月 -97','DD-MON-RR'),'SH_CLERK',4450,null,123,50);
Insert into ZS.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('01-7月 -98','DD-MON-RR'),'SH_CLERK',4450,null,123,50);
Insert into ZS.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('17-5月 -99','DD-MON-RR'),'SH_CLERK',4450,null,123,50);
Insert into ZS.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('24-4月 -98','DD-MON-RR'),'SH_CLERK',4450,null,124,50);
Insert into ZS.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('23-5月 -98','DD-MON-RR'),'SH_CLERK',4450,null,124,50);
Insert into ZS.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('21-1月 -99','DD-MON-RR'),'SH_CLERK',4450,null,124,50);
Insert into ZS.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('13-6月 -00','DD-MON-RR'),'SH_CLERK',4450,null,124,50);
Insert into ZS.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('17-9月 -87','DD-MON-RR'),'AD_ASST',4400,null,101,20);
Insert into ZS.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('17-11月-96','DD-MON-RR'),'MK_MAN',13000,null,100,20);
Insert into ZS.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('17-8月 -97','DD-MON-RR'),'MK_REP',6000,null,201,20);
Insert into ZS.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('07-1月 -94','DD-MON-RR'),'HR_REP',6500,null,101,40);
Insert into ZS.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('07-1月 -94','DD-MON-RR'),'PR_REP',10000,null,101,70);
Insert into ZS.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('07-1月 -94','DD-MON-RR'),'AC_MGR',12000,null,101,110);
Insert into ZS.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('07-1月 -94','DD-MON-RR'),'AC_ACCOUNT',8300,null,205,110);
Insert into ZS.EMPLOYEES (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (2019,'Eleni','wood','wood@neusoft.edu.cn','011.44.1344.429018',to_date('29-6月 -00','DD-MON-RR'),'SA_MAN',10500,0.2,100,80);
REM INSERTING into ZS.EMP_10
SET DEFINE OFF;
REM INSERTING into ZS.EMP_20
SET DEFINE OFF;
Insert into ZS.EMP_20 (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('17-9月 -87','DD-MON-RR'),'AD_ASST',4400,null,101,20);
Insert into ZS.EMP_20 (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('17-11月-96','DD-MON-RR'),'MK_MAN',13000,null,100,20);
Insert into ZS.EMP_20 (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('17-8月 -97','DD-MON-RR'),'MK_REP',6000,null,201,20);
REM INSERTING into ZS.EMP_30
SET DEFINE OFF;
Insert into ZS.EMP_30 (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('07-12月-94','DD-MON-RR'),'PU_MAN',11000,null,100,30);
Insert into ZS.EMP_30 (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('18-5月 -95','DD-MON-RR'),'PU_CLERK',3100,null,114,30);
Insert into ZS.EMP_30 (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('24-12月-97','DD-MON-RR'),'PU_CLERK',2900,null,114,30);
Insert into ZS.EMP_30 (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('24-7月 -97','DD-MON-RR'),'PU_CLERK',2800,null,114,30);
Insert into ZS.EMP_30 (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('15-11月-98','DD-MON-RR'),'PU_CLERK',2600,null,114,30);
Insert into ZS.EMP_30 (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('10-8月 -99','DD-MON-RR'),'PU_CLERK',2500,null,114,30);
REM INSERTING into ZS.EMP_MGR
SET DEFINE OFF;
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (100,null,24000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (101,100,17000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (102,100,17000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (103,102,9000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (108,101,12000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (109,108,9000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (110,108,8200);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (114,100,11000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (121,100,8200);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (145,100,14000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (146,100,13500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (147,100,12000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (148,100,11000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (149,100,10500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (150,145,10000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (151,145,9500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (152,145,9000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (156,146,10000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (157,146,9500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (158,146,9000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (162,147,10500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (163,147,9500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (168,148,11500);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (169,148,10000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (170,148,9600);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (174,149,11000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (175,149,8800);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (176,149,8600);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (177,149,8400);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (201,100,13000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (204,101,10000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (205,101,12000);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (206,205,8300);
Insert into ZS.EMP_MGR (EMPLOYEE_ID,MANAGER_ID,SALARY) values (2019,100,10500);
REM INSERTING into ZS.EMP_OTHER
SET DEFINE OFF;
Insert into ZS.EMP_OTHER (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('17-1月 -87','DD-MON-RR'),'AD_PRES',24000,null,null,90);
Insert into ZS.EMP_OTHER (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('21-9月 -89','DD-MON-RR'),'AD_VP',17000,null,100,90);
Insert into ZS.EMP_OTHER (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('13-6月 -93','DD-MON-RR'),'AD_VP',17000,null,100,90);
Insert into ZS.EMP_OTHER (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('03-6月 -90','DD-MON-RR'),'IT_PROG',9000,null,102,60);
Insert into ZS.EMP_OTHER (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('21-5月 -91','DD-MON-RR'),'IT_PROG',6000,null,103,60);
Insert into ZS.EMP_OTHER (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('25-1月 -97','DD-MON-RR'),'IT_PROG',4800,null,103,60);
Insert into ZS.EMP_OTHER (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('05-11月-98','DD-MON-RR'),'IT_PROG',4800,null,103,60);
Insert into ZS.EMP_OTHER (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('07-11月-99','DD-MON-RR'),'IT_PROG',4200,null,103,60);
Insert into ZS.EMP_OTHER (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('17-8月 -94','DD-MON-RR'),'FI_MGR',12000,null,101,100);
Insert into ZS.EMP_OTHER (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('16-8月 -94','DD-MON-RR'),'FI_ACCOUNT',9000,null,108,100);
Insert into ZS.EMP_OTHER (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('28-9月 -97','DD-MON-RR'),'FI_ACCOUNT',8200,null,108,100);
Insert into ZS.EMP_OTHER (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('30-9月 -97','DD-MON-RR'),'FI_ACCOUNT',7700,null,108,100);
Insert into ZS.EMP_OTHER (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('07-5月 -98','DD-MON-RR'),'FI_ACCOUNT',7800,null,108,100);
Insert into ZS.EMP_OTHER (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('07-12月-99','DD-MON-RR'),'FI_ACCOUNT',6900,null,108,100);
Insert into ZS.EMP_OTHER (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('18-7月 -96','DD-MON-RR'),'ST_MAN',8000,null,100,50);
Insert into ZS.EMP_OTHER (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('10-4月 -97','DD-MON-RR'),'ST_MAN',8200,null,100,50);
Insert into ZS.EMP_OTHER (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('01-5月 -95','DD-MON-RR'),'ST_MAN',7900,null,100,50);
Insert into ZS.EMP_OTHER (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月-97','DD-MON-RR'),'ST_MAN',6500,null,100,50);
Insert into ZS.EMP_OTHER (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('16-11月-99','DD-MON-RR'),'ST_MAN',5800,null,100,50);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (125,'07ia','Nayer','JNAYER','650.124.1214',to_date('16-7月 -97','DD-MON-RR'),'ST_CLERK',3200,null,120,50);
Insert into ZS.EMP_OTHER (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('28-9月 -98','DD-MON-RR'),'ST_CLERK',2700,null,120,50);
Insert into ZS.EMP_OTHER (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('14-6月 -99','DD-MON-RR'),'ST_CLERK',2400,null,120,50);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (128,'Steven','05kle','S05KLE','650.124.1434',to_date('08-5月 -00','DD-MON-RR'),'ST_CLERK',2200,null,120,50);
Insert into ZS.EMP_OTHER (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('20-8月 -97','DD-MON-RR'),'ST_CLERK',3300,null,121,50);
Insert into ZS.EMP_OTHER (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('30-10月-97','DD-MON-RR'),'ST_CLERK',2800,null,121,50);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (131,'James','05low','JAMRLOW','650.124.7234',to_date('16-11月-97','DD-MON-RR'),'ST_CLERK',2500,null,121,50);
Insert into ZS.EMP_OTHER (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('10-4月 -99','DD-MON-RR'),'ST_CLERK',2100,null,121,50);
Insert into ZS.EMP_OTHER (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('14-1月 -96','DD-MON-RR'),'ST_CLERK',3300,null,122,50);
Insert into ZS.EMP_OTHER (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('26-8月 -98','DD-MON-RR'),'ST_CLERK',2900,null,122,50);
Insert into ZS.EMP_OTHER (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月-99','DD-MON-RR'),'ST_CLERK',2400,null,122,50);
Insert into ZS.EMP_OTHER (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('06-11月-00','DD-MON-RR'),'ST_CLERK',2200,null,122,50);
Insert into ZS.EMP_OTHER (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('14-7月 -95','DD-MON-RR'),'ST_CLERK',3600,null,123,50);
Insert into ZS.EMP_OTHER (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('26-10月-97','DD-MON-RR'),'ST_CLERK',3200,null,123,50);
Insert into ZS.EMP_OTHER (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('12-11月-98','DD-MON-RR'),'ST_CLERK',2700,null,123,50);
Insert into ZS.EMP_OTHER (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('06-4月 -98','DD-MON-RR'),'ST_CLERK',2500,null,123,50);
Insert into ZS.EMP_OTHER (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('17-10月-95','DD-MON-RR'),'ST_CLERK',3500,null,124,50);
Insert into ZS.EMP_OTHER (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('29-6月 -97','DD-MON-RR'),'ST_CLERK',3100,null,124,50);
Insert into ZS.EMP_OTHER (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('15-5月 -98','DD-MON-RR'),'ST_CLERK',2600,null,124,50);
Insert into ZS.EMP_OTHER (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('09-7月 -98','DD-MON-RR'),'ST_CLERK',2500,null,124,50);
Insert into ZS.EMP_OTHER (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('01-10月-96','DD-MON-RR'),'SA_MAN',14000,0.4,100,80);
Insert into ZS.EMP_OTHER (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('05-6月 -97','DD-MON-RR'),'SA_MAN',13500,0.3,100,80);
Insert into ZS.EMP_OTHER (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('10-5月 -97','DD-MON-RR'),'SA_MAN',12000,0.3,100,80);
Insert into ZS.EMP_OTHER (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('15-10月-99','DD-MON-RR'),'SA_MAN',11000,0.3,100,80);
Insert into ZS.EMP_OTHER (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('29-6月 -00','DD-MON-RR'),'SA_MAN',10500,0.2,100,80);
Insert into ZS.EMP_OTHER (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('30-6月 -97','DD-MON-RR'),'SA_REP',10000,0.3,145,80);
Insert into ZS.EMP_OTHER (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('24-5月 -97','DD-MON-RR'),'SA_REP',9500,0.25,145,80);
Insert into ZS.EMP_OTHER (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('20-8月 -97','DD-MON-RR'),'SA_REP',9000,0.25,145,80);
Insert into ZS.EMP_OTHER (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('30-5月 -98','DD-MON-RR'),'SA_REP',8000,0.2,145,80);
Insert into ZS.EMP_OTHER (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('09-12月-98','DD-MON-RR'),'SA_REP',7500,0.2,145,80);
Insert into ZS.EMP_OTHER (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('23-11月-99','DD-MON-RR'),'SA_REP',7000,0.15,145,80);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (156,'06ette','King','JKING','011.44.1345.429268',to_date('30-6月 -96','DD-MON-RR'),'SA_REP',10000,0.35,146,80);
Insert into ZS.EMP_OTHER (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('04-5月 -96','DD-MON-RR'),'SA_REP',9500,0.35,146,80);
Insert into ZS.EMP_OTHER (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('01-8月 -96','DD-MON-RR'),'SA_REP',9000,0.35,146,80);
Insert into ZS.EMP_OTHER (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('10-5月 -97','DD-MON-RR'),'SA_REP',8000,0.3,146,80);
Insert into ZS.EMP_OTHER (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('15-12月-97','DD-MON-RR'),'SA_REP',7500,0.3,146,80);
Insert into ZS.EMP_OTHER (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('03-11月-98','DD-MON-RR'),'SA_REP',7000,0.25,146,80);
Insert into ZS.EMP_OTHER (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月-97','DD-MON-RR'),'SA_REP',10500,0.25,147,80);
Insert into ZS.EMP_OTHER (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('19-5月 -99','DD-MON-RR'),'SA_REP',9500,0.15,147,80);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (164,'Mattea','05vins','M05VINS','011.44.1346.329268',to_date('24-6月 -00','DD-MON-RR'),'SA_REP',7200,0.1,147,80);
Insert into ZS.EMP_OTHER (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('23-11月-00','DD-MON-RR'),'SA_REP',6800,0.1,147,80);
Insert into ZS.EMP_OTHER (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('24-5月 -00','DD-MON-RR'),'SA_REP',6400,0.1,147,80);
Insert into ZS.EMP_OTHER (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('21-4月 -00','DD-MON-RR'),'SA_REP',6200,0.1,147,80);
Insert into ZS.EMP_OTHER (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('11-5月 -97','DD-MON-RR'),'SA_REP',11500,0.25,148,80);
Insert into ZS.EMP_OTHER (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('23-5月 -98','DD-MON-RR'),'SA_REP',10000,0.2,148,80);
Insert into ZS.EMP_OTHER (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('24-6月 -98','DD-MON-RR'),'SA_REP',9600,0.2,148,80);
Insert into ZS.EMP_OTHER (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('23-11月-99','DD-MON-RR'),'SA_REP',7400,0.15,148,80);
Insert into ZS.EMP_OTHER (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('24-5月 -99','DD-MON-RR'),'SA_REP',7300,0.15,148,80);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (173,'Sundita','Ku05','SKU05','011.44.1343.329268',to_date('21-4月 -00','DD-MON-RR'),'SA_REP',6100,0.1,148,80);
Insert into ZS.EMP_OTHER (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('11-5月 -96','DD-MON-RR'),'SA_REP',11000,0.3,149,80);
Insert into ZS.EMP_OTHER (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('19-5月 -97','DD-MON-RR'),'SA_REP',8800,0.25,149,80);
Insert into ZS.EMP_OTHER (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('24-5月 -98','DD-MON-RR'),'SA_REP',8600,0.2,149,80);
Insert into ZS.EMP_OTHER (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('23-4月 -98','DD-MON-RR'),'SA_REP',8400,0.2,149,80);
Insert into ZS.EMP_OTHER (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('24-5月 -99','DD-MON-RR'),'SA_REP',7000,0.15,149,null);
Insert into ZS.EMP_OTHER (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('04-6月 -00','DD-MON-RR'),'SA_REP',6200,0.1,149,80);
Insert into ZS.EMP_OTHER (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('24-6月 -98','DD-MON-RR'),'SH_CLERK',3200,null,120,50);
Insert into ZS.EMP_OTHER (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('23-11月-98','DD-MON-RR'),'SH_CLERK',3100,null,120,50);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (182,'05tha','Sullivan','MSULLIVA','650.507.9878',to_date('21-1月 -99','DD-MON-RR'),'SH_CLERK',2500,null,120,50);
Insert into ZS.EMP_OTHER (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('03-11月-00','DD-MON-RR'),'SH_CLERK',2800,null,120,50);
Insert into ZS.EMP_OTHER (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('27-6月 -96','DD-MON-RR'),'SH_CLERK',4200,null,121,50);
Insert into ZS.EMP_OTHER (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('20-11月-97','DD-MON-RR'),'SH_CLERK',4100,null,121,50);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (186,'07ia','Dellinger','JDELLING','650.509.3876',to_date('24-1月 -98','DD-MON-RR'),'SH_CLERK',3400,null,121,50);
Insert into ZS.EMP_OTHER (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('07-11月-99','DD-MON-RR'),'SH_CLERK',3000,null,121,50);
Insert into ZS.EMP_OTHER (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('14-1月 -97','DD-MON-RR'),'SH_CLERK',3800,null,122,50);
Insert into ZS.EMP_OTHER (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('13-8月 -97','DD-MON-RR'),'SH_CLERK',3600,null,122,50);
Insert into ZS.EMP_OTHER (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('11-7月 -98','DD-MON-RR'),'SH_CLERK',2900,null,122,50);
Insert into ZS.EMP_OTHER (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('19-12月-99','DD-MON-RR'),'SH_CLERK',2500,null,122,50);
Insert into ZS.EMP_OTHER (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('04-11月-96','DD-MON-RR'),'SH_CLERK',4000,null,123,50);
Insert into ZS.EMP_OTHER (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-5月 -97','DD-MON-RR'),'SH_CLERK',3900,null,123,50);
Insert into ZS.EMP_OTHER (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('01-7月 -98','DD-MON-RR'),'SH_CLERK',3200,null,123,50);
Insert into ZS.EMP_OTHER (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('17-5月 -99','DD-MON-RR'),'SH_CLERK',2800,null,123,50);
Insert into ZS.EMP_OTHER (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('24-4月 -98','DD-MON-RR'),'SH_CLERK',3100,null,124,50);
Insert into ZS.EMP_OTHER (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('23-5月 -98','DD-MON-RR'),'SH_CLERK',3000,null,124,50);
Insert into ZS.EMP_OTHER (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('21-1月 -99','DD-MON-RR'),'SH_CLERK',2600,null,124,50);
Insert into ZS.EMP_OTHER (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('13-6月 -00','DD-MON-RR'),'SH_CLERK',2600,null,124,50);
Insert into ZS.EMP_OTHER (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('07-1月 -94','DD-MON-RR'),'HR_REP',6500,null,101,40);
Insert into ZS.EMP_OTHER (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('07-1月 -94','DD-MON-RR'),'PR_REP',10000,null,101,70);
Insert into ZS.EMP_OTHER (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('07-1月 -94','DD-MON-RR'),'AC_MGR',12000,null,101,110);
Insert into ZS.EMP_OTHER (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('07-1月 -94','DD-MON-RR'),'AC_ACCOUNT',8300,null,205,110);
Insert into ZS.EMP_OTHER (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) values (2019,'Eleni','wood','wood@neusoft.edu.cn','011.44.1344.429018',to_date('29-6月 -00','DD-MON-RR'),'SA_MAN',10500,0.2,100,80);
REM INSERTING into ZS.EMP_SAL
SET DEFINE OFF;
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (100,to_date('17-1月 -87','DD-MON-RR'),24000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (101,to_date('21-9月 -89','DD-MON-RR'),17000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (102,to_date('13-6月 -93','DD-MON-RR'),17000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (103,to_date('03-6月 -90','DD-MON-RR'),9000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (108,to_date('17-8月 -94','DD-MON-RR'),12000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (109,to_date('16-8月 -94','DD-MON-RR'),9000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (110,to_date('28-9月 -97','DD-MON-RR'),8200);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (114,to_date('07-12月-94','DD-MON-RR'),11000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (121,to_date('10-4月 -97','DD-MON-RR'),8200);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (145,to_date('01-10月-96','DD-MON-RR'),14000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (146,to_date('05-6月 -97','DD-MON-RR'),13500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (147,to_date('10-5月 -97','DD-MON-RR'),12000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (148,to_date('15-10月-99','DD-MON-RR'),11000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (149,to_date('29-6月 -00','DD-MON-RR'),10500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (150,to_date('30-6月 -97','DD-MON-RR'),10000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (151,to_date('24-5月 -97','DD-MON-RR'),9500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (152,to_date('20-8月 -97','DD-MON-RR'),9000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (156,to_date('30-6月 -96','DD-MON-RR'),10000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (157,to_date('04-5月 -96','DD-MON-RR'),9500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (158,to_date('01-8月 -96','DD-MON-RR'),9000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (162,to_date('11-11月-97','DD-MON-RR'),10500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (163,to_date('19-5月 -99','DD-MON-RR'),9500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (168,to_date('11-5月 -97','DD-MON-RR'),11500);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (169,to_date('23-5月 -98','DD-MON-RR'),10000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (170,to_date('24-6月 -98','DD-MON-RR'),9600);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (174,to_date('11-5月 -96','DD-MON-RR'),11000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (175,to_date('19-5月 -97','DD-MON-RR'),8800);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (176,to_date('24-5月 -98','DD-MON-RR'),8600);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (177,to_date('23-4月 -98','DD-MON-RR'),8400);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (201,to_date('17-11月-96','DD-MON-RR'),13000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (204,to_date('07-1月 -94','DD-MON-RR'),10000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (205,to_date('07-1月 -94','DD-MON-RR'),12000);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (206,to_date('07-1月 -94','DD-MON-RR'),8300);
Insert into ZS.EMP_SAL (EMPLOYEE_ID,HIRE_DATE,SALARY) values (2019,to_date('29-6月 -00','DD-MON-RR'),10500);
REM INSERTING into ZS.JOBS
SET DEFINE OFF;
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('AD_PRES','President',20000,40000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('AD_VP','Administration Vice President',15000,30000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('AD_ASST','Administration Assistant',3000,6000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('FI_MGR','Finance Manager',8200,16000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('FI_ACCOUNT','Accountant',4200,9000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('AC_MGR','Accounting Manager',8200,16000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('AC_ACCOUNT','Public Accountant',4200,9000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('SA_MAN','Sales Manager',10000,20000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('SA_REP','Sales Representative',6000,12000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('PU_MAN','Purchasing Manager',8000,15000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('PU_CLERK','Purchasing Clerk',2500,5500);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('ST_MAN','Stock Manager',5500,8500);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('ST_CLERK','Stock Clerk',2000,5000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('SH_CLERK','Shipping Clerk',2500,5500);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('IT_PROG','Programmer',4000,10000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('MK_MAN','05keting Manager',9000,15000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('MK_REP','05keting Representative',4000,9000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('HR_REP','Human Resources Representative',4000,9000);
Insert into ZS.JOBS (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) values ('PR_REP','Public Relations Representative',4500,10500);
REM INSERTING into ZS.JOB_HISTORY
SET DEFINE OFF;
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (102,to_date('13-6月 -93','DD-MON-RR'),to_date('24-7月 -98','DD-MON-RR'),'IT_PROG',60);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (101,to_date('21-9月 -89','DD-MON-RR'),to_date('27-10月-93','DD-MON-RR'),'AC_ACCOUNT',110);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (101,to_date('28-10月-93','DD-MON-RR'),to_date('15-5月 -97','DD-MON-RR'),'AC_MGR',110);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (201,to_date('17-11月-96','DD-MON-RR'),to_date('19-12月-99','DD-MON-RR'),'MK_REP',20);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (114,to_date('24-5月 -98','DD-MON-RR'),to_date('31-12月-99','DD-MON-RR'),'ST_CLERK',50);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (122,to_date('01-6月 -99','DD-MON-RR'),to_date('31-12月-99','DD-MON-RR'),'ST_CLERK',50);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (200,to_date('17-9月 -87','DD-MON-RR'),to_date('17-1月 -93','DD-MON-RR'),'AD_ASST',90);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (176,to_date('24-5月 -98','DD-MON-RR'),to_date('31-12月-98','DD-MON-RR'),'SA_REP',80);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (176,to_date('01-6月 -99','DD-MON-RR'),to_date('31-12月-99','DD-MON-RR'),'SA_MAN',80);
Insert into ZS.JOB_HISTORY (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) values (200,to_date('01-7月 -94','DD-MON-RR'),to_date('31-12月-98','DD-MON-RR'),'AC_ACCOUNT',90);
REM INSERTING into ZS.LOCATIONS
SET DEFINE OFF;
Insert into ZS.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 ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1100,'93091 Calle della Testa','10934','Venice',null,'IT');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1200,'2017 Shinjuku-ku','1689','Tokyo','Tokyo Prefecture','JP');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1300,'9450 Kamiya-cho','6823','Hiroshima',null,'JP');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1400,'2014 Jabberwocky Rd','26192','Southlake','Texas','US');
Insert into ZS.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 ZS.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 ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1700,'2004 Charade Rd','98199','Seattle','Washington','US');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1800,'147 Spadina Ave','M5V 2L7','Toronto','Ontario','CA');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (1900,'6092 Boxwood St','YSW 9T2','Whitehorse','Yukon','CA');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (2000,'40-5-12 Laogianggen','190518','Beijing',null,'CN');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (2100,'1298 Vileparle (E)','490231','Bombay','Maharashtra','IN');
Insert into ZS.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 ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (2300,'198 Clementi North','540198','Singapore',null,'SG');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (2400,'8204 Arthur St',null,'London',null,'UK');
Insert into ZS.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 ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (2600,'9702 Chester Road','09629850293','Stretford','Manchester','UK');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (2700,'Schwanthalerstr. 7031','80925','Munich','Bavaria','DE');
Insert into ZS.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 ZS.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 ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (3000,'Murtenstrasse 921','3095','Bern','BE','CH');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (3100,'Pieter Breughelstraat 837','3029SK','Utrecht','Utrecht','NL');
Insert into ZS.LOCATIONS (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) values (3200,'05iano Escobedo 9991','11932','Mexico City','Distrito Federal,','MX');
REM INSERTING into ZS.REGIONS
SET DEFINE OFF;
Insert into ZS.REGIONS (REGION_ID,REGION_NAME) values (1,'Europe');
Insert into ZS.REGIONS (REGION_ID,REGION_NAME) values (2,'Americas');
Insert into ZS.REGIONS (REGION_ID,REGION_NAME) values (3,'Asia');
Insert into ZS.REGIONS (REGION_ID,REGION_NAME) values (4,'Middle East and Africa');
REM INSERTING into ZS.SAL_GRADES
SET DEFINE OFF;
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (1,0,1000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (2,1001,2000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (3,2001,3000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (4,3001,4000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (5,4001,5000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (6,5001,6000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (7,6001,7000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (8,7001,8000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (9,8001,9000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (10,9001,10000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (11,10001,11000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (12,11001,12000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (13,12001,13000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (14,13001,14000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (15,14001,15000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (16,15001,16000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (17,16001,17000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (18,17001,18000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (19,18001,19000);
Insert into ZS.SAL_GRADES (GRADE,MIN_SALARY,MAX_SALARY) values (20,19001,20000);
REM INSERTING into ZS.SOURCE_EMP
SET DEFINE OFF;
Insert into ZS.SOURCE_EMP (EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID) values (100,'john',10);
Insert into ZS.SOURCE_EMP (EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID) values (110,'smith',20);
Insert into ZS.SOURCE_EMP (EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID) values (120,'tom',30);
Insert into ZS.SOURCE_EMP (EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID) values (100,'marry',20);
Insert into ZS.SOURCE_EMP (EMPLOYEE_ID,LAST_NAME,DEPARTMENT_ID) values (20,'jack',40);
REM INSERTING into ZS.TARGET_EMP
SET DEFINE OFF;
REM INSERTING into ZS.USERS
SET DEFINE OFF;
--------------------------------------------------------
-- DDL for Index JHIST_EMP_ID_ST_DATE_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "ZS"."JHIST_EMP_ID_ST_DATE_PK" ON "ZS"."JOB_HISTORY" ("EMPLOYEE_ID", "START_DATE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- Constraints for Table DEPT_SALARY_STAT
--------------------------------------------------------
ALTER TABLE "ZS"."DEPT_SALARY_STAT" ADD PRIMARY KEY ("DEPARTMENT_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table EMP_20
--------------------------------------------------------
ALTER TABLE "ZS"."EMP_20" MODIFY ("JOB_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_20" MODIFY ("HIRE_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_20" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_20" MODIFY ("LAST_NAME" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table EMP_SAL
--------------------------------------------------------
ALTER TABLE "ZS"."EMP_SAL" MODIFY ("HIRE_DATE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table SAL_GRADES
--------------------------------------------------------
ALTER TABLE "ZS"."SAL_GRADES" ADD PRIMARY KEY ("GRADE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table LOCATIONS
--------------------------------------------------------
ALTER TABLE "ZS"."LOCATIONS" MODIFY ("CITY" NOT NULL ENABLE);
ALTER TABLE "ZS"."LOCATIONS" ADD PRIMARY KEY ("LOCATION_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table EMP_30
--------------------------------------------------------
ALTER TABLE "ZS"."EMP_30" MODIFY ("JOB_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_30" MODIFY ("HIRE_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_30" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_30" MODIFY ("LAST_NAME" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table EMP_OTHER
--------------------------------------------------------
ALTER TABLE "ZS"."EMP_OTHER" MODIFY ("JOB_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_OTHER" MODIFY ("HIRE_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_OTHER" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_OTHER" MODIFY ("LAST_NAME" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table EMP_10
--------------------------------------------------------
ALTER TABLE "ZS"."EMP_10" MODIFY ("JOB_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_10" MODIFY ("HIRE_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_10" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMP_10" MODIFY ("LAST_NAME" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table COUNTRIES
--------------------------------------------------------
ALTER TABLE "ZS"."COUNTRIES" ADD PRIMARY KEY ("COUNTRY_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table JOB_HISTORY
--------------------------------------------------------
ALTER TABLE "ZS"."JOB_HISTORY" MODIFY ("EMPLOYEE_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."JOB_HISTORY" MODIFY ("START_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."JOB_HISTORY" MODIFY ("END_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."JOB_HISTORY" MODIFY ("JOB_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."JOB_HISTORY" ADD CONSTRAINT "JHIST_DATE_INTERVAL" CHECK (end_date > start_date) ENABLE;
ALTER TABLE "ZS"."JOB_HISTORY" ADD CONSTRAINT "JHIST_EMP_ID_ST_DATE_PK" PRIMARY KEY ("EMPLOYEE_ID", "START_DATE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table EMPLOYEES
--------------------------------------------------------
ALTER TABLE "ZS"."EMPLOYEES" MODIFY ("LAST_NAME" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMPLOYEES" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMPLOYEES" MODIFY ("HIRE_DATE" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMPLOYEES" MODIFY ("JOB_ID" NOT NULL ENABLE);
ALTER TABLE "ZS"."EMPLOYEES" ADD CHECK (salary > 0) ENABLE;
ALTER TABLE "ZS"."EMPLOYEES" ADD PRIMARY KEY ("EMPLOYEE_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
ALTER TABLE "ZS"."EMPLOYEES" ADD UNIQUE ("EMAIL")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table DEPARTMENTS
--------------------------------------------------------
ALTER TABLE "ZS"."DEPARTMENTS" MODIFY ("DEPARTMENT_NAME" NOT NULL ENABLE);
ALTER TABLE "ZS"."DEPARTMENTS" ADD PRIMARY KEY ("DEPARTMENT_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table USERS
--------------------------------------------------------
ALTER TABLE "ZS"."USERS" MODIFY ("PASSWORD" NOT NULL ENABLE);
ALTER TABLE "ZS"."USERS" ADD PRIMARY KEY ("USER_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table REGIONS
--------------------------------------------------------
ALTER TABLE "ZS"."REGIONS" ADD PRIMARY KEY ("REGION_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table JOBS
--------------------------------------------------------
ALTER TABLE "ZS"."JOBS" MODIFY ("JOB_TITLE" NOT NULL ENABLE);
ALTER TABLE "ZS"."JOBS" ADD PRIMARY KEY ("JOB_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table COUNTRIES
--------------------------------------------------------
ALTER TABLE "ZS"."COUNTRIES" ADD FOREIGN KEY ("REGION_ID")
REFERENCES "ZS"."REGIONS" ("REGION_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table DEPARTMENTS
--------------------------------------------------------
ALTER TABLE "ZS"."DEPARTMENTS" ADD FOREIGN KEY ("LOCATION_ID")
REFERENCES "ZS"."LOCATIONS" ("LOCATION_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table EMPLOYEES
--------------------------------------------------------
ALTER TABLE "ZS"."EMPLOYEES" ADD FOREIGN KEY ("JOB_ID")
REFERENCES "ZS"."JOBS" ("JOB_ID") ENABLE;
ALTER TABLE "ZS"."EMPLOYEES" ADD FOREIGN KEY ("DEPARTMENT_ID")
REFERENCES "ZS"."DEPARTMENTS" ("DEPARTMENT_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table JOB_HISTORY
--------------------------------------------------------
ALTER TABLE "ZS"."JOB_HISTORY" ADD FOREIGN KEY ("EMPLOYEE_ID")
REFERENCES "ZS"."EMPLOYEES" ("EMPLOYEE_ID") ENABLE;
ALTER TABLE "ZS"."JOB_HISTORY" ADD FOREIGN KEY ("JOB_ID")
REFERENCES "ZS"."JOBS" ("JOB_ID") ENABLE;
ALTER TABLE "ZS"."JOB_HISTORY" ADD FOREIGN KEY ("DEPARTMENT_ID")
REFERENCES "ZS"."DEPARTMENTS" ("DEPARTMENT_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table LOCATIONS
--------------------------------------------------------
ALTER TABLE "ZS"."LOCATIONS" ADD FOREIGN KEY ("COUNTRY_ID")
REFERENCES "ZS"."COUNTRIES" ("COUNTRY_ID") ENABLE;
题目
- 第7章
-- 创建表dept_salary_stat
CREATE TABLE dept_salary_stat
(
department_id NUMBER(20) PRIMARY KEY,
max_salaey NUMBER(20),
min_salary NUMBER(20)
);
-- 统计各个部门的部门号、部门最高工资和部门最低工资， 并将统计结果写入表dept_salary_stat
INSERT INTO dept_salary_stat
SELECT department_id,
MAX(salary),
MIN(salary)
FROM employees
GROUP BY department_id;
-- 向employees表中插入一个员工信息，员工号位2019，员工姓名为wood，email为wood@neusoft.edu.cn
-- 其他信息与员工号位149的员工信息相同
INSERT INTO employees
SELECT 2019,
first_name,
'wood',
'wood@neusoft.edu.cn',
phone_number,
hire_date,
job_id,
salary,
commission_pct,
manager_id,
department_id
FROM employees
WHERE employee_id=149;
-- 假设有两个表emp_sal和emp_mgr， 其定义分别为
create table emp_sal
as
select employee_id, hire_date, salary from employees where 1=2;
create table emp_mgr
as
select employee_id, manager_id, salary from employees where 1=2;
-- 利用无条件表插入，查询employees表中工资高于8000元的员工信息并分别插入emp_sal和emp_mgr
insert all
into emp_sal values(employee_id, hire_date, salary)
into emp_mgr values(employee_id, manager_id, salary)
select employee_id, hire_date, manager_id, salary from employees
where salary>8000;
-- 将employees表中的员工信息按不同部门号分别复制到emp10，emp20，emp30和emp_other表中
-- 建表
create table emp_10 as select * from employees where 1=2;
create table emp_20 as select * from employees where 1=2;
create table emp_30 as select * from employees where 1=2;
create table emp_other as select * from employees where 1=2;
-- 插入
insert first
when department_id=10 then into emp_10
when department_id=20 then into emp_20
when department_id=30 then into emp_30
else into emp_other
select * from employees;
-- 查询
select * from emp_10;
select * from emp_20;
select * from emp_30;
select * from emp_other;
-- 将50号部门的员工工资设置为30号部门的平均工资加300元
update employees set salary=300+(select avg(salary) from employees
where department_id=30) where department_id=50;
-- 现有表source_emp和target_emp，表中数据如下。利用source_emp表中的数据更新target表中的数据
-- 对target_emp表中存在的员工信息进行更新，对不存在的员工进行信息插入
--建表
create table source_emp(
employee_id number(20),
last_name varchar2(20),
department_id number(20)
);
-- 插入数据
insert into source_emp values(100, 'john', 10);
insert into source_emp values(110, 'smith', 20);
insert into source_emp values(120, 'tom', 30);
-- 建表
create table target_emp(
employee_id number(20),
last_name varchar2(20),
department_id number(20)
);
-- 插入数据
insert into source_emp values(100, 'marry', 20);
insert into source_emp values(20, 'jack', 40);
-- merge语句执行更新操作还是插入操作
merge into target_emp t using source_emp s
on (t.employee_id=s.employee_id)
when matched then update set
t.last_name=s.last_name, t.department_id=s.department_id
when not matched then insert
values(s.employee_id, s.last_name, s.department_id);
-- 查询验证
select * from target_emp;
-- 事务回滚
-- 部分回滚事务
-- 全部回滚事务
-- 如果只想取消事务中的部分操作，而不是取消全部操作，则可以在事务内部设置保存点
-- 将一个大的事务划分为若干个组成部分，这样就可以将事务回滚到指定的保存点
-- 可以使用savepoint语句设置保存点
insert into departments values(400, 'accounting', 100, 1400);
insert into departments values(410, 'accounting', 120, 1500);
savepoint a;
update departments set location_id=1500 where department_id=400;
savepoint b;
insert into departments values(420, 'research', 130, 1700);
-- 在该事务提交之前，可以执行rollback命令全部或部分回滚事务中的操作。
rollback to b; -- 回滚最后一个insert操作
rollback to a; -- 回滚后面的insert操作和update操作
rollback; -- 回滚全部操作
- 第9章
-- 首先执行下面指令，输出语句正常使用
set serveroutput on;
-- 例题9-4 查询109号员工的工资以及140号员工名与工资， 并输出
declare
v_sal employees.salary%type;
-- 如果要定义一个类型与某个变量的数据类型或数据库中某个列
-- 的数据类型一致（不知道该变量或列的数据类型）的变量可以用%type实现
v_emp employees%rowtype;
--如果要定义一个与数据库中某个表结构一致的记录类型的变量可以使用%rowtype实现
begin
select salary into v_sal from employees where employee_id=109;
select * into v_emp from employees where employee_id=140;
dbms_output.put_line(v_sal);
dbms_output.put_line(v_emp.first_name||v_emp.salary);
-- || 这个符号 是字符串连接符
end;
-- 分号;一定不能少
-- 例题9-7 根据员工名或员工号查询员工信息
declare
v_emp employees%rowtype;
v_lname employees.last_name%type;
v_sal employees.salary%type;
begin
select * into v_emp from employees where last_name='Bell';
dbms_output.put_line(v_emp.employee_id||' '||v_emp.salary);
select last_name, salary into v_lname, v_sal from employees
where employee_id=109;
dbms_output.put_line(v_lname||' '||v_sal);
end;
-- 例题9-9 输入一个员工号， 修改该员工的工资。如果该员工位10号部门，则工资增加100元，
-- 若为20号部门，则工资增加140元，若为30号部门，则工资增加200元，否则增加300元
declare
v_deptno employees.department_id%type;
v_increment number(4);
v_empno employees.employee_id%type;
begin
v_empno:=&x; -- := 是赋值， &x弹出一个可以输入的对话框
select department_id into v_deptno from employees where
employee_id=v_empno;
if v_deptno=10 then v_increment:=100;
elsif v_deptno=20 then v_increment:=140;
elsif v_deptno=30 then v_increment:=200;
else v_increment:=300;
end if;
update employees set salary=salary+v_increment
where employee_id=v_empno;
end;
-- 例题9-12 利用where循环求1-100之间的偶数的和
declare
v_counter binary_integer :=1;
v_sum number :=0;
begin
while v_counter<=100 loop
if mod(v_counter,2)=0 then
v_sum:=v_sum+v_counter;
end if;
v_counter:=v_counter+1;
end loop;
dbms_output.put_line(v_sum);
end;
-- 例题9-13 利用for循环求出1-100之间偶数的和
declare
v_sum number :=0;
begin
for v_counter in 1..100 loop -- 1..100代表 1 - 100的范围 包括1和100
if mod(v_counter, 2)=0 then
v_sum:=v_sum+v_counter;
end if;
end loop;
dbms_output.put_line(v_sum);
end;
-- .. 范围 例子测试
declare
begin
for i in 1..100 loop
dbms_output.put_line(i);
end loop;
end;
-- 编写一个PL/SQL语句块，输出所有比本部门平均工资高的员工信息
-- 下面的例子是错误的，未更改
declare
v_emp employees%rowtype;
v_avg employees.salary%type;
begin
select avg(salary) into v_avg from employees where
department_id=20;
select * into v_emp from employees where
salary > v_avg;
for i in 1..v_emp.count loop
dbms_output.put_line(v_emp(i).first_name);
end loop;
dbms_output.put_line(v_avg);
end;