Notice
Recent Posts
Recent Comments
Link
Everything has an expiration date
[Oracle] 20231031 [팀 과제 - 샘플 스키마 재구성] - 20231031_03_HR 본문
[Oracle]/SQL (Program source)
[Oracle] 20231031 [팀 과제 - 샘플 스키마 재구성] - 20231031_03_HR
Jelly-fish 2023. 11. 1. 23:17
팀 과제 - 샘플 스키마(데이터베이스) 재구성
[20231031_03_hr(4팀_김지민).sql]
SELECT USER
FROM DUAL;
--==>> HR
-- *(제출하는 파일은 각자 다 제출!!)
--■■■ 팀 별 실습 수행 과제 ■■■--
-- 제출 파일명
-- · 20231031_03_hr(4팀_김지민).sql
-- · 20231031_03_hr(4팀_김지민) 수행후기.txt
-- HR 샘플스키마 ERD 를 이용한 테이블 재구성~!!!
-- 팀별로... HR 샘플스키마에 있는 기본 테이블(7개)
-- COUNTRIES / DEPARTMENS / EMPLOYEES / JOBS / JOB_HISTORY / LOCATIONS / REGIONS
-- 을 똑~~~~~~~~~~ 같이 새로 구성한다.
-- 단, 생성하는 테이블의 이름은 『테이블명+팀번호』 (컬럼명은 그대로)
-- COUNTRIES1 / DEPARTMENS1 / EMPLOYEES1 / JOBS1 / JOB_HISTORY1 / LOCATIONS1 / REGIONS1
-- → 1팀
-- COUNTRIES2 / DEPARTMENS2 / EMPLOYEES2 / JOBS2 / JOB_HISTORY2 / LOCATIONS2 / REGIONS2
-- → 2팀
-- COUNTRIES3 / DEPARTMENS3 / EMPLOYEES3 / JOBS3 / JOB_HISTORY3 / LOCATIONS3 / REGIONS3
-- → 3팀
-- COUNTRIES4 / DEPARTMENS4 / EMPLOYEES4 / JOBS4 / JOB_HISTORY4 / LOCATIONS4 / REGIONS4
-- → 4팀
-- CREATE TABLE AS 금지!!
-- INSERT INTO 를 실행하는 과정에서 직접 문제 발생 분석.
-- 1. 기존 대상 테이블들의 정보 수집
-- 2. 테이블 생성(컬럼이름, 자료형, DEFAULT 표현식, NOT NULL 등....)
-- 3. 제약조건 설정(PK, U, FK, CK, ....)
-- 4. 데이터 입력
-- 최상위 부모
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'COUNTRIES';
SELECT *
FROM USER_CONSTRAINTS;
--【 위치 】=========================================================
-- ① [대륙(지역) 기준]
SELECT *
FROM REGIONS;
/*
REGION_ID REGION_NAME
*/
-- ② [국가 기준]
SELECT *
FROM COUNTRIES;
/*
COUNTRY_ID COUNTRY_NAME REGION_ID
*/
-- ③ [국가 내부 거주 지역 기준]
SELECT *
FROM LOCATIONS;
/*
LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY_ID
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'DEPARTMENTS';
SELECT *
FROM USER_CONSTRAINTS;
-- ④ [지역별 부서 위치]
SELECT *
FROM DEPARTMENTS;
/*
DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
*/
--【 직업 】=========================================================
-- ① [직업]
SELECT *
FROM JOBS;
/*
JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOBS';
/*
DEPARTMENT MANAGER_ID
10 Administration 200
20 Marketing 201
30 Purchasing 114
40 Human Resources 203
50 Shipping 121
60 IT 103
70 Public Relations 204
80 Sales 145
90 Executive 100
100 Finance 108
110 Accounting 205
*/
DESC EMPLOYEES;
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOBS';
-- ② [사원]
SELECT *
FROM EMPLOYEES;
/*
EMPLOYEE_ID MANAGER_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER
HIRE_DATE COMMISSION_PCT
[JOBS] JOB_ID SALARY
[] DEPARTMENT_ID
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOB_HISTORY';
-- ③ [퇴사자 기록]
SELECT *
FROM JOB_HISTORY;
--=====================================================================
/*
REGIONS4, COUNTRIES4 정현욱
LOCATIONS4 길현욱
DEPARTMENTS4 엄재용
JOBS4, EMPLOYEES4 박나영
JOB_HISTORY4 김지민
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOB_HISTORY';
CREATE TABLE JOB_HISTORY4
( EMPLOYEE_ID NUMBER(6) CONSTRAINT JOB_HISTORY4_EMPLOYEE_ID_NN NOT NULL
, START_DATE DATE CONSTRAINT JOB_HISTORY4_START_DATE_NN NOT NULL
, END_DATE DATE CONSTRAINT JOB_HISTORY4_END_DATE_NN NOT NULL
, JOB_ID VARCHAR2(10) CONSTRAINT JOB_HISTORY4_JOB_ID_NN NOT NULL
, DEPARTMENT_ID NUMBER(4)
);
ALTER TABLE JOB_HISTORY4
ADD (
CONSTRAINT JOB_HIST4_EMP_ID_ST_DATE_PK PRIMARY KEY (EMPLOYEE_ID, START_DATE)
, CONSTRAINT JOB_HIST4_EMP_ID_FK FOREIGN KEY (EMPLOYEE_ID)
REFERENCES EMPLOYEES4(EMPLOYEE_ID)
, CONSTRAINT JOB_HIST4_DATE_INTERVAL CHECK(END_DATE > START_DATE)
, CONSTRAINT JOB_HIST4_JOB_ID_FK FOREIGN KEY(JOB_ID)
REFERENCES JOBS4(JOB_ID)
, CONSTRAINT JOB_HIST4_DEPT_FK FOREIGN KEY(DEPARTMENT_ID)
REFERENCES DEPARTMENTS4(DEPARTMENT_ID)
);
DROP TABLE JOB_HISTORY4 PU
DESC JOB_HISTORY4;
DESC JOB_HISTORY;
--○ 제약조건 확인 ================================================
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOB_HISTORY4'
ORDER BY CONSTRAINT_TYPE, COLUMN_NAME;
/*
"EMPLOYEE_ID" IS NOT NULL
end_date > start_date
"END_DATE" IS NOT NULL
"JOB_ID" IS NOT NULL
end_date > start_date
"START_DATE" IS NOT NULL
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOB_HISTORY'
ORDER BY CONSTRAINT_TYPE, COLUMN_NAME;
/*
"EMPLOYEE_ID" IS NOT NULL
"END_DATE" IS NOT NULL
END_DATE > START_DATE
"JOB_ID" IS NOT NULL
"START_DATE" IS NOT NULL
END_DATE > START_DATE
*/
--=====================================================
-- 제약조건 확인
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'TTABLE1';
-- WHERE TABLE_NAME IN ('REGIONS', 'COUNTRIES', 'LOCATIONS', 'DEPARTMENTS'
-- , 'JOBS', 'EMPLOYEES', 'JOB_HISTORY' )
ORDER BY TABLE_NAME;
--DESC REGIONS;
--
--SELECT *
--FROM VIEW_CONSTCHECK
--WHERE TABLE_NAME = 'REGIONS';
--
--
--CREATE TABLE RTESTT
--( REGION_ID NUMBER CONSTRAINT RTESTT_ID_NN NOT NULL
--, REGION_NAME VARCHAR2(25)
--);
--
--
--DROP TABLE RTESTT PURGE;
--
--ALTER TABLE RTESTT
--ADD (CONSTRAINT RTESTT_REGION_ID_PK PRIMARY KEY(REGION_ID));
--
--
--DESC REGIONS;
--DESC RTESTT;
--
--SELECT *
--FROM VIEW_CONSTCHECK
--WHERE TABLE_NAME = 'RTESTT';
CREATE TABLE EMPTEST1
AS
SELECT *
FROM EMPLOYEES;
DESC EMPTEST1;
INSERT TO EMPTEST1(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,
, JOB_ID, SA
팀 과제 최종 제출물 sql
--■■■ 팀 별 실습 수행 과제 ■■■--
-- 제출 파일명
-- · 20231031_03_hr(4팀_김지민).sql
-- · 20231031_03_hr(4팀_김지민) 수행후기.txt
--[테이블 생성]==================================================================
--[정현욱 팀장 파트]**********************************************
-- ⓐ【REGIONS4 테이블 생성 및 제약조건 추가】
-- ① 컬럼 레벨에서 제약조건 추가 : NOT NULL 조건
-- (DESCRIBE 실행했을 때 제대로 NOT NULL이 조회되도록 컬럼 레벨에서 작성.)
CREATE TABLE REGIONS4
( REGION_ID NUMBER CONSTRAINT REGION4_ID_NN NOT NULL
, REGION_NAME VARCHAR2(25)
);
-- ② 추가적인 제약 조건 : PRIMARY KEY 설정.
ALTER TABLE REGIONS4
ADD ( CONSTRAINT REG4_ID_PK PRIMARY KEY(REGION_ID) );
------------------------------------------------------------------
-- ⓑ 【COUNTRIES4 테이블 생성 및 제약조건 추가】
-- ① 컬럼 레벨에서 제약조건 추가 : NOT NULL 조건
-- (DESCRIBE 실행했을 때 제대로 NOT NULL이 조회되도록 컬럼 레벨에서 작성.)
CREATE TABLE COUNTRIES4
( COUNTRY_ID CHAR(2) CONSTRAINT CONURTY4_ID_NN NOT NULL
, COUNTRY_NAME VARCHAR2(40)
, REGION_ID NUMBER
);
-- ② 추가적인 제약 조건 : PRIMARY KEY, FOREIGN KEY 설정.
ALTER TABLE COUNTRIES4
ADD ( CONSTRAINT COUNTRY4_C_ID_PK PRIMARY KEY(COUNTRY_ID)
, CONSTRAINT COUNTRY4_REG_FK FOREIGN KEY(REGION_ID)
REFERENCES REGIONS4(REGION_ID));
--**********************************************************
--[길현욱 팀원 파트]*****************************************
-- ⓐ 【LOCATIONS4 테이블 생성 및 제약조건 추가】
-- ① 테이블 레벨에서 제약조건 설정 (PRIMARY KEY, FOREIGN KEY)
CREATE TABLE LOCATIONS4
( LOCATION_ID NUMBER(4) --P
, STREET_ADDRESS VARCHAR2(40)
, POSTAL_CODE VARCHAR2(12)
, CITY VARCHAR2(30) -- C
, STATE_PROVINCE VARCHAR2(25)
, COUNTRY_ID CHAR(2) -- R
, CONSTRAINT LOC4_ID_PK PRIMARY KEY(LOCATION_ID)
, CONSTRAINT LOC4_C_ID_FK FOREIGN KEY(COUNTRY_ID)
REFERENCES COUNTRIES4(COUNTRY_ID)
);
-- ② NOT NULL이 제대로 조회될 수 있도록
-- MODIFY를 통해 NOT NULL 제약조건 설정.
ALTER TABLE LOCATIONS4
MODIFY CITY VARCHAR2(30) CONSTRAINT LOC4_CITY_NN NOT NULL;
--**********************************************************
--[엄재용 팀원 파트]*****************************************
-- ⓐ 【DEPARTMENTS4 테이블 생성 및 제약조건 추가】
-- ① 테이블 레벨에서 제약조건 설정 (PRIMARY KEY, FOREIGN KEY)----
CREATE TABLE DEPARTMENTS4
( DEPARTMENT_ID NUMBER(4)
, DEPARTMENT_NAME VARCHAR2(30)
, MANAGER_ID NUMBER(6)
, LOCATION_ID NUMBER(4)
, CONSTRAINT DEPT4_ID_PK PRIMARY KEY(DEPARTMENT_ID)
, CONSTRAINT DEPT4_LOC_FK FOREIGN KEY(LOCATION_ID)
REFERENCES LOCATIONS4(LOCATION_ID)
);
-- ② NOT NULL 제약조건 MODIFY로 설정.
-- [ⓐ, ⓑ, ⓒ 과정을 거치지 않고 NOT NULL 제약조건명 설정하기]〓〓〓〓〓〓
-- ALTER TABLE [테이블명]
-- MODIFY [컬럼명] [데이터 타입] CONSTRAINT [제약조건명] NOT NULL;
-- 〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓
-- ⓐ MODIFY 를 통해 NOT NULL 제약조건 지정.
-- 오라클이 임의로 제약조건명 생성 (EX : 'SYS_C007107')
ALTER TABLE DEPARTMENTS4
MODIFY DEPARTMENT_NAME NOT NULL;
-- ⓑ 오라클이 임의로 지어준 제약조건명이 무엇인지 확인
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'DEPARTMENTS4';
--==>> SYS_C007284
-- ⓒ 오라클이 임의로 지어준 제약조건명을, 'DEPT4_NAME_NN'으로 변경.
ALTER TABLE DEPARTMENTS4
RENAME CONSTRAINT SYS_C007284 TO
DEPT4_NAME_NN;
-- [EMPLOYEES4 테이블을 생성한 이후에 추가할 제약조건]
-- [EMPLOYEES4의 EMPLOYEE_ID를 FOREIGN KEY로 사용하므로 바로 제약조건 추가불가.]
-- ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
-- ⓓ
ALTER TABLE DEPARTMENTS4
ADD CONSTRAINT DEPT4_MGR_FK FOREIGN KEY(MANAGER_ID)
REFERENCES EMPLOYEES4(EMPLOYEE_ID);
-- ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
--==>> EMPLOYEES4에서도 DEPARTMENTS4의 DEPARTMENT_ID를 참조하므로
-- 우선 DEPARTMENTS를 생성하되, MANAGER_ID를 FOREIGN KEY로 지정하지 않았다.
-- EMPLOYEES4의 테이블 생성이 끝난 후에 바로 이 쿼리문을 실행시켜서
-- 제약조건을 추가해 주어야 한다.
--**************************************************************
--[박나영 팀원 파트]*********************************************
-- ⓐ 【JOBS4 테이블 생성 및 제약조건 추가】
-- ① 컬럼 레벨에서 제약조건 설정 (PRIMARY KEY, NOT NULL)
CREATE TABLE JOBS4
( JOB_ID VARCHAR2(10) CONSTRAINT JOB4_ID_PK PRIMARY KEY
, JOB_TITLE VARCHAR2(35) CONSTRAINT JOB4_TITLE_NN NOT NULL
, MIN_SALARY NUMBER(6)
, MAX_SALARY NUMBER(6)
);
-- ⓑ 【EMPLOYEES4 테이블 생성 및 제약조건 추가】
-- ① 컬럼 레벨에서 제약 조건 설정 (PRIMARY KEY, NOT NULL, FOREIGN KEY, CHECK)
CREATE TABLE EMPLOYEES4
( EMPLOYEE_ID NUMBER(6) CONSTRAINT EMP4_EMP_ID_PK PRIMARY KEY
, FIRST_NAME VARCHAR2(20)
, LAST_NAME VARCHAR2(25) CONSTRAINT EMP4_LAST_NAME_NN NOT NULL
, EMAIL VARCHAR2(25) CONSTRAINT EMP4_EMAIL_NN NOT NULL
, PHONE_NUMBER VARCHAR2(20)
, HIRE_DATE DATE CONSTRAINT EMP4_HIRE_DATE_NN NOT NULL
, JOB_ID VARCHAR2(10) CONSTRAINT EMP4_JOB_NN NOT NULL
, SALARY NUMBER(8,2) CONSTRAINT EMP4_SALARY_MIN CHECK(SALARY > 0)
, COMMISSION_PCT NUMBER(2,2)
, MANAGER_ID NUMBER(6) CONSTRAINT EMP4_MANAGER_FK REFERENCES EMPLOYEES4(EMPLOYEE_ID)
, DEPARTMENT_ID NUMBER(4) CONSTRAINT EMP4_DEPT_FK REFERENCES DEPARTMENTS4(DEPARTMENT_ID)
);
-- ② 제약조건 추가 (UNIQUE, FOREIGN KEY) : 테이블 레벨(테이블 생성 후 제약조건 추가)
ALTER TABLE EMPLOYEES4 ADD CONSTRAINT EMP4_EMAIL_UK UNIQUE(EMAIL);
ALTER TABLE EMPLOYEES4 ADD (CONSTRAINT EMP4_JOB_FK FOREIGN KEY(JOB_ID) REFERENCES JOBS4(JOB_ID));
--************************************************************
--[김지민 파트]************************************************************
-- ⓐ 【JOB_HISTORY4 테이블 생성 및 제약조건 추가】
-- ① 컬럼 레벨에서 제약조건 추가 (NOT NULL만 추가)
CREATE TABLE JOB_HISTORY4
(
EMPLOYEE_ID NUMBER(6) CONSTRAINT JHIST4_EMPLOYEE_NN NOT NULL
, START_DATE DATE CONSTRAINT JHIST4_START_DATE_NN NOT NULL
, END_DATE DATE CONSTRAINT JHIST4_END_DATE_NN NOT NULL
, JOB_ID VARCHAR2(10) CONSTRAINT JHIST4_JOB_NN NOT NULL
, DEPARTMENT_ID NUMBER(4)
);
-- ▶ JOB_HISTORY4 테이블에는 하나의 컬럼 당 추가되는 제약 조건이
-- 다른 테이블들에 비해 가짓수가 많은 편이었습니다.
-- ▶ DESCRIBE 명령어를 통해 테이블을 묘사했을 때, NOT NULLL 제약조건이
-- 분명하게 표시될 수 있도록
-- 컬럼 레벨에서는 우선적으로 NOT NULL 제약조건만을 작성했습니다.
-- 컬럼 레벨에서는 컬럼 하나에 여러 개의 제약조건을 추가할 수가 없었습니다.
-- * (ADD (CONSTRAINT [제약조건명] 제약조건)불가, 제약조건 쉼표구분 불가)
--② 컬럼 하나 당, NOT NULL 이외의 제약 조건을 갖는 항목들을
-- 테이블 레벨에서(테이블 생성 후 추가) 제약조건을 추가로 지정해 주는 방식으로
-- PRIMARY KEY와, FOREIGN KEY, CHECK 제약조건 추가.
ALTER TABLE JOB_HISTORY4
ADD
(
CONSTRAINT JHIST4_EMP_ID_ST_DATE_PK PRIMARY KEY (EMPLOYEE_ID, START_DATE)
, CONSTRAINT JHIST4_EMP_ID_FK FOREIGN KEY (EMPLOYEE_ID)
REFERENCES EMPLOYEES4(EMPLOYEE_ID)
, CONSTRAINT JHIST4_DATE_INTERVAL CHECK(END_DATE > START_DATE)
, CONSTRAINT JHIST4_JOB_ID_FK FOREIGN KEY(JOB_ID)
REFERENCES JOBS4(JOB_ID)
, CONSTRAINT JHIST4_DEPT_FK FOREIGN KEY(DEPARTMENT_ID)
REFERENCES DEPARTMENTS4(DEPARTMENT_ID)
);
--[테이블 생성 종료]=============================================================
--[제약조건 확인]================================================================
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'REGIONS4';
--==>>
/*
==============================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
==============================================================================================================
HR REGION4_ID_NN REGIONS4 C REGION_ID "REGION_ID" IS NOT NULL (null)
HR REG4_ID_PK REGIONS4 P REGION_ID (null) (null)
==============================================================================================================
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'COUNTRIES4';
--==>>
/*
==========================================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
==========================================================================================================================
HR CONURTY4_ID_NN COUNTRIES4 C COUNTRY_ID "COUNTRY_ID" IS NOT NULL (null)
HR COUNTRY4_C_ID_PK COUNTRIES4 P COUNTRY_ID
HR COUNTRY4_REG_FK COUNTRIES4 R REGION_ID (null) NO ACTION
==========================================================================================================================
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'LOCATIONS4';
--==>>
/*
==========================================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
==========================================================================================================================
HR LOC4_ID_PK LOCATIONS4 P LOCATION_ID (null) (null)
HR LOC4_C_ID_FK LOCATIONS4 R COUNTRY_ID (null) NO ACTION
HR LOC4_CITY_NN LOCATIONS4 C CITY "CITY" IS NOT NULL (null)
==========================================================================================================================
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'DEPARTMENTS4';
--==>>
/*
=======================================================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
=======================================================================================================================================
HR DEPT4_MGR_FK DEPARTMENTS4 R MANAGER_ID (null) NO ACTION
HR DEPT4_ID_PK DEPARTMENTS4 P DEPARTMENT_ID (null) (null)
HR DEPT4_LOC_FK DEPARTMENTS4 R LOCATION_ID NO ACTION
HR DEPT4_NAME_NN DEPARTMENTS4 C DEPARTMENT_NAME "DEPARTMENT_NAME" IS NOT NULL (null)
=======================================================================================================================================
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOBS4';
--==>>
/*
===================================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
===================================================================================================================
HR JOB4_TITLE_NN JOBS4 C JOB_TITLE "JOB_TITLE" IS NOT NULL (null)
HR JOB4_ID_PK JOBS4 P JOB_ID (null) (null)
===================================================================================================================
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'EMPLOYEES4';
--==>>
/*
=================================================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
=================================================================================================================================
HR EMP4_LAST_NAME_NN EMPLOYEES4 C LAST_NAME "LAST_NAME" IS NOT NULL (null)
HR EMP4_EMAIL_NN EMPLOYEES4 C EMAIL "EMAIL" IS NOT NULL (null)
HR EMP4_HIRE_DATE_NN EMPLOYEES4 C HIRE_DATE "HIRE_DATE" IS NOT NULL (null)
HR EMP4_JOB_NN EMPLOYEES4 C JOB_ID "JOB_ID" IS NOT NULL (null)
HR EMP4_SALARY_MIN EMPLOYEES4 C SALARY SALARY > 0 (null)
HR EMP4_EMP_ID_PK EMPLOYEES4 P EMPLOYEE_ID (null) (null)
HR EMP4_MANAGER_FK EMPLOYEES4 R MANAGER_ID (null) NO ACTION
HR EMP4_DEPT_FK EMPLOYEES4 R DEPARTMENT_ID (null) NO ACTION
HR EMP4_EMAIL_UK EMPLOYEES4 U EMAIL (null) (null)
HR EMP4_JOB_FK EMPLOYEES4 R JOB_ID (null) NO ACTION
==================================================================================================================================
*/
SELECT *
FROM VIEW_CONSTCHECK
WHERE TABLE_NAME = 'JOB_HISTORY4';
--==>>
/*
============================================================================================================================================
OWNER CONSTRAINT_NAME TABLE_NAME CONSTRAINT_TYPE COLUMN_NAME SEARCH_CONDITION DELETE_RULE
============================================================================================================================================
HR JHIST4_EMPLOYEE_NN JOB_HISTORY4 C EMPLOYEE_ID "EMPLOYEE_ID" IS NOT NULL (null)
HR JHIST4_START_DATE_NN JOB_HISTORY4 C START_DATE "START_DATE" IS NOT NULL (null)
HR JHIST4_END_DATE_NN JOB_HISTORY4 C END_DATE "END_DATE" IS NOT NULL (null)
HR JHIST4_JOB_NN JOB_HISTORY4 C JOB_ID "JOB_ID" IS NOT NULL (null)
HR JHIST4_EMP_ID_ST_DATE_PK JOB_HISTORY4 P EMPLOYEE_ID (null) (null)
HR JHIST4_EMP_ID_ST_DATE_PK JOB_HISTORY4 P START_DATE (null) (null)
HR JHIST4_DATE_INTERVAL JOB_HISTORY4 C START_DATE END_DATE > START_DATE (null)
HR JHIST4_DATE_INTERVAL JOB_HISTORY4 C END_DATE END_DATE > START_DATE (null)
HR JHIST4_EMP_ID_FK JOB_HISTORY4 R EMPLOYEE_ID (null) NO ACTION
HR JHIST4_JOB_ID_FK JOB_HISTORY4 R JOB_ID (null) NO ACTION
HR JHIST4_DEPT_FK JOB_HISTORY4 R DEPARTMENT_ID (null) NO ACTION
============================================================================================================================================
*/
--[제약조건 확인 종료]===========================================================
-- 자동 INSERT 생성 구문
SELECT /*insert*/ * FROM REGIONS;
SELECT /*insert*/ * FROM COUNTRIES;
SELECT /*insert*/ * FROM LOCATIONS;
SELECT /*insert*/ * FROM DEPARTMENTS;
SELECT /*insert*/ * FROM JOBS;
SELECT /*insert*/ * FROM JOB_HISTORY;
SELECT /*insert*/ * FROM EMPLOYEES;
SELECT *
FROM USER_SEQUENCES;
--○ REGIONS4 테이블 데이터 입력--------------------------------------------------
INSERT INTO REGIONS4 (REGION_ID,REGION_NAME) VALUES (1,'Europe');
INSERT INTO REGIONS4 (REGION_ID,REGION_NAME) VALUES (2,'Americas');
INSERT INTO REGIONS4 (REGION_ID,REGION_NAME) VALUES (3,'Asia');
INSERT INTO REGIONS4 (REGION_ID,REGION_NAME) VALUES (4,'Middle East and Africa');
--○ COUNTRIES4 테이블 데이터 입력------------------------------------------------
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('AR','Argentina',2);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('AU','Australia',3);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('BE','Belgium',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('BR','Brazil',2);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('CA','Canada',2);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('CH','Switzerland',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('CN','China',3);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('DE','Germany',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('DK','Denmark',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('EG','Egypt',4);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('FR','France',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('IL','Israel',4);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('IN','India',3);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('IT','Italy',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('JP','Japan',3);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('KW','Kuwait',4);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('ML','Malaysia',3);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('MX','Mexico',2);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('NG','Nigeria',4);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('NL','Netherlands',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('SG','Singapore',3);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('UK','United Kingdom',1);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('US','United States of America',2);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('ZM','Zambia',4);
INSERT INTO COUNTRIES4 (COUNTRY_ID,COUNTRY_NAME,REGION_ID) VALUES ('ZW','Zimbabwe',4);
--○ LOCATIONS4 테이블 데이터 입력------------------------------------------------
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'1297 Via Cola di Rie','00989','Roma',null,'IT');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'93091 Calle della Testa','10934','Venice',null,'IT');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'2017 Shinjuku-ku','1689','Tokyo','Tokyo Prefecture','JP');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'9450 Kamiya-cho','6823','Hiroshima',null,'JP');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'2014 Jabberwocky Rd','26192','Southlake','Texas','US');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'2011 Interiors Blvd','99236','South San Francisco','California','US');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'2007 Zagora St','50090','South Brunswick','New Jersey','US');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'2004 Charade Rd','98199','Seattle','Washington','US');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'147 Spadina Ave','M5V 2L7','Toronto','Ontario','CA');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'6092 Boxwood St','YSW 9T2','Whitehorse','Yukon','CA');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'40-5-12 Laogianggen','190518','Beijing',null,'CN');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'1298 Vileparle (E)','490231','Bombay','Maharashtra','IN');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'12-98 Victoria Street','2901','Sydney','New South Wales','AU');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'198 Clementi North','540198','Singapore',null,'SG');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'8204 Arthur St',null,'London',null,'UK');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'Magdalen Centre, The Oxford Science Park','OX9 9ZB','Oxford','Oxford','UK');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'9702 Chester Road','09629850293','Stretford','Manchester','UK');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'Schwanthalerstr. 7031','80925','Munich','Bavaria','DE');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'Rua Frei Caneca 1360 ','01307-002','Sao Paulo','Sao Paulo','BR');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'20 Rue des Corps-Saints','1730','Geneva','Geneve','CH');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'Murtenstrasse 921','3095','Bern','BE','CH');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'Pieter Breughelstraat 837','3029SK','Utrecht','Utrecht','NL');
INSERT INTO LOCATIONS4 (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNTRY_ID) VALUES (LOCATIONS4_SEQ.NEXTVAL,'Mariano Escobedo 9991','11932','Mexico City','Distrito Federal,','MX');
--○ DEPARTMENTS4 테이블 데이터 입력---------------------------------------------
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Administration',200,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Marketing',201,1800);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Purchasing',114,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Human Resources',203,2400);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Shipping',121,1500);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'IT',103,1400);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Public Relations',204,2700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Sales',145,2500);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Executive',100,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Finance',108,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Accounting',205,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Treasury',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Corporate Tax',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Control And Credit',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Shareholder Services',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Benefits',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Manufacturing',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Construction',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Contracting',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Operations',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'IT Support',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'NOC',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'IT Helpdesk',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Government Sales',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Retail Sales',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Recruiting',null,1700);
INSERT INTO DEPARTMENTS4 (DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID) VALUES (DEPARTMENTS4_SEQ.NEXTVAL,'Payroll',null,1700);
--○ JOBS4 테이블 데이터 입력----------------------------------------------------
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('AD_PRES','President',20080,40000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('AD_VP','Administration Vice President',15000,30000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('AD_ASST','Administration Assistant',3000,6000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('FI_MGR','Finance Manager',8200,16000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('FI_ACCOUNT','Accountant',4200,9000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('AC_MGR','Accounting Manager',8200,16000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('AC_ACCOUNT','Public Accountant',4200,9000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('SA_MAN','Sales Manager',10000,20080);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('SA_REP','Sales Representative',6000,12008);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('PU_MAN','Purchasing Manager',8000,15000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('PU_CLERK','Purchasing Clerk',2500,5500);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('ST_MAN','Stock Manager',5500,8500);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('ST_CLERK','Stock Clerk',2008,5000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('SH_CLERK','Shipping Clerk',2500,5500);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('IT_PROG','Programmer',4000,10000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('MK_MAN','Marketing Manager',9000,15000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('MK_REP','Marketing Representative',4000,9000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('HR_REP','Human Resources Representative',4000,9000);
INSERT INTO JOBS4 (JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY) VALUES ('PR_REP','Public Relations Representative',4500,10500);
--○ EMPLOYEES4 테이블 데이터 입력-----------------------------------------------
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Steven','King','SKING','515.123.4567',TO_DATE('2003-06-17','YYYY-MM-DD'),'AD_PRES',24000,null,null,90);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Neena','Kochhar','NKOCHHAR','515.123.4568',TO_DATE('2005-09-21','YYYY-MM-DD'),'AD_VP',17000,null,100,90);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Lex','De Haan','LDEHAAN','515.123.4569',TO_DATE('2001-01-13','YYYY-MM-DD'),'AD_VP',17000,null,100,90);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Alexander','Hunold','AHUNOLD','590.423.4567',TO_DATE('2006-01-03','YYYY-MM-DD'),'IT_PROG',9000,null,102,60);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Bruce','Ernst','BERNST','590.423.4568',TO_DATE('2007-05-21','YYYY-MM-DD'),'IT_PROG',6000,null,103,60);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'David','Austin','DAUSTIN','590.423.4569',TO_DATE('2005-06-25','YYYY-MM-DD'),'IT_PROG',4800,null,103,60);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Valli','Pataballa','VPATABAL','590.423.4560',TO_DATE('2006-02-05','YYYY-MM-DD'),'IT_PROG',4800,null,103,60);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Diana','Lorentz','DLORENTZ','590.423.5567',TO_DATE('2007-02-07','YYYY-MM-DD'),'IT_PROG',4200,null,103,60);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Nancy','Greenberg','NGREENBE','515.124.4569',TO_DATE('2002-08-17','YYYY-MM-DD'),'FI_MGR',12008,null,101,100);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Daniel','Faviet','DFAVIET','515.124.4169',TO_DATE('2002-08-16','YYYY-MM-DD'),'FI_ACCOUNT',9000,null,108,100);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'John','Chen','JCHEN','515.124.4269',TO_DATE('2005-09-28','YYYY-MM-DD'),'FI_ACCOUNT',8200,null,108,100);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Ismael','Sciarra','ISCIARRA','515.124.4369',TO_DATE('2005-09-30','YYYY-MM-DD'),'FI_ACCOUNT',7700,null,108,100);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jose Manuel','Urman','JMURMAN','515.124.4469',TO_DATE('2006-03-07','YYYY-MM-DD'),'FI_ACCOUNT',7800,null,108,100);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Luis','Popp','LPOPP','515.124.4567',TO_DATE('2007-12-07','YYYY-MM-DD'),'FI_ACCOUNT',6900,null,108,100);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Den','Raphaely','DRAPHEAL','515.127.4561',TO_DATE('2002-12-07','YYYY-MM-DD'),'PU_MAN',11000,null,100,30);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Alexander','Khoo','AKHOO','515.127.4562',TO_DATE('2003-05-18','YYYY-MM-DD'),'PU_CLERK',3100,null,114,30);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Shelli','Baida','SBAIDA','515.127.4563',TO_DATE('2005-12-24','YYYY-MM-DD'),'PU_CLERK',2900,null,114,30);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Sigal','Tobias','STOBIAS','515.127.4564',TO_DATE('2005-07-24','YYYY-MM-DD'),'PU_CLERK',2800,null,114,30);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Guy','Himuro','GHIMURO','515.127.4565',TO_DATE('2006-11-15','YYYY-MM-DD'),'PU_CLERK',2600,null,114,30);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Karen','Colmenares','KCOLMENA','515.127.4566',TO_DATE('2007-08-10','YYYY-MM-DD'),'PU_CLERK',2500,null,114,30);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Matthew','Weiss','MWEISS','650.123.1234',TO_DATE('2004-07-18','YYYY-MM-DD'),'ST_MAN',8000,null,100,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Adam','Fripp','AFRIPP','650.123.2234',TO_DATE('2005-04-10','YYYY-MM-DD'),'ST_MAN',8200,null,100,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Payam','Kaufling','PKAUFLIN','650.123.3234',TO_DATE('2003-05-01','YYYY-MM-DD'),'ST_MAN',7900,null,100,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Shanta','Vollman','SVOLLMAN','650.123.4234',TO_DATE('2005-10-10','YYYY-MM-DD'),'ST_MAN',6500,null,100,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Kevin','Mourgos','KMOURGOS','650.123.5234',TO_DATE('2007-11-16','YYYY-MM-DD'),'ST_MAN',5800,null,100,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Julia','Nayer','JNAYER','650.124.1214',TO_DATE('2005-07-16','YYYY-MM-DD'),'ST_CLERK',3200,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Irene','Mikkilineni','IMIKKILI','650.124.1224',TO_DATE('2006-09-28','YYYY-MM-DD'),'ST_CLERK',2700,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'James','Landry','JLANDRY','650.124.1334',TO_DATE('2007-01-14','YYYY-MM-DD'),'ST_CLERK',2400,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Steven','Markle','SMARKLE','650.124.1434',TO_DATE('2008-03-08','YYYY-MM-DD'),'ST_CLERK',2200,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Laura','Bissot','LBISSOT','650.124.5234',TO_DATE('2005-08-20','YYYY-MM-DD'),'ST_CLERK',3300,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Mozhe','Atkinson','MATKINSO','650.124.6234',TO_DATE('2005-10-30','YYYY-MM-DD'),'ST_CLERK',2800,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'James','Marlow','JAMRLOW','650.124.7234',TO_DATE('2005-02-16','YYYY-MM-DD'),'ST_CLERK',2500,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'TJ','Olson','TJOLSON','650.124.8234',TO_DATE('2007-04-10','YYYY-MM-DD'),'ST_CLERK',2100,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jason','Mallin','JMALLIN','650.127.1934',TO_DATE('2004-06-14','YYYY-MM-DD'),'ST_CLERK',3300,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Michael','Rogers','MROGERS','650.127.1834',TO_DATE('2006-08-26','YYYY-MM-DD'),'ST_CLERK',2900,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Ki','Gee','KGEE','650.127.1734',TO_DATE('2007-12-12','YYYY-MM-DD'),'ST_CLERK',2400,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Hazel','Philtanker','HPHILTAN','650.127.1634',TO_DATE('2008-02-06','YYYY-MM-DD'),'ST_CLERK',2200,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Renske','Ladwig','RLADWIG','650.121.1234',TO_DATE('2003-07-14','YYYY-MM-DD'),'ST_CLERK',3600,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Stephen','Stiles','SSTILES','650.121.2034',TO_DATE('2005-10-26','YYYY-MM-DD'),'ST_CLERK',3200,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'John','Seo','JSEO','650.121.2019',TO_DATE('2006-02-12','YYYY-MM-DD'),'ST_CLERK',2700,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Joshua','Patel','JPATEL','650.121.1834',TO_DATE('2006-04-06','YYYY-MM-DD'),'ST_CLERK',2500,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Trenna','Rajs','TRAJS','650.121.8009',TO_DATE('2003-10-17','YYYY-MM-DD'),'ST_CLERK',3500,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Curtis','Davies','CDAVIES','650.121.2994',TO_DATE('2005-01-29','YYYY-MM-DD'),'ST_CLERK',3100,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Randall','Matos','RMATOS','650.121.2874',TO_DATE('2006-03-15','YYYY-MM-DD'),'ST_CLERK',2600,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Peter','Vargas','PVARGAS','650.121.2004',TO_DATE('2006-07-09','YYYY-MM-DD'),'ST_CLERK',2500,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'John','Russell','JRUSSEL','011.44.1344.429268',TO_DATE('2004-10-01','YYYY-MM-DD'),'SA_MAN',14000,0.4,100,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Karen','Partners','KPARTNER','011.44.1344.467268',TO_DATE('2005-01-05','YYYY-MM-DD'),'SA_MAN',13500,0.3,100,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278',TO_DATE('2005-03-10','YYYY-MM-DD'),'SA_MAN',12000,0.3,100,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Gerald','Cambrault','GCAMBRAU','011.44.1344.619268',TO_DATE('2007-10-15','YYYY-MM-DD'),'SA_MAN',11000,0.3,100,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018',TO_DATE('2008-01-29','YYYY-MM-DD'),'SA_MAN',10500,0.2,100,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Peter','Tucker','PTUCKER','011.44.1344.129268',TO_DATE('2005-01-30','YYYY-MM-DD'),'SA_REP',10000,0.3,145,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'David','Bernstein','DBERNSTE','011.44.1344.345268',TO_DATE('2005-03-24','YYYY-MM-DD'),'SA_REP',9500,0.25,145,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Peter','Hall','PHALL','011.44.1344.478968',TO_DATE('2005-08-20','YYYY-MM-DD'),'SA_REP',9000,0.25,145,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Christopher','Olsen','COLSEN','011.44.1344.498718',TO_DATE('2006-03-30','YYYY-MM-DD'),'SA_REP',8000,0.2,145,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Nanette','Cambrault','NCAMBRAU','011.44.1344.987668',TO_DATE('2006-12-09','YYYY-MM-DD'),'SA_REP',7500,0.2,145,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Oliver','Tuvault','OTUVAULT','011.44.1344.486508',TO_DATE('2007-11-23','YYYY-MM-DD'),'SA_REP',7000,0.15,145,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Janette','King','JKING','011.44.1345.429268',TO_DATE('2004-01-30','YYYY-MM-DD'),'SA_REP',10000,0.35,146,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Patrick','Sully','PSULLY','011.44.1345.929268',TO_DATE('2004-03-04','YYYY-MM-DD'),'SA_REP',9500,0.35,146,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Allan','McEwen','AMCEWEN','011.44.1345.829268',TO_DATE('2004-08-01','YYYY-MM-DD'),'SA_REP',9000,0.35,146,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Lindsey','Smith','LSMITH','011.44.1345.729268',TO_DATE('2005-03-10','YYYY-MM-DD'),'SA_REP',8000,0.3,146,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Louise','Doran','LDORAN','011.44.1345.629268',TO_DATE('2005-12-15','YYYY-MM-DD'),'SA_REP',7500,0.3,146,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Sarath','Sewall','SSEWALL','011.44.1345.529268',TO_DATE('2006-11-03','YYYY-MM-DD'),'SA_REP',7000,0.25,146,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Clara','Vishney','CVISHNEY','011.44.1346.129268',TO_DATE('2005-11-11','YYYY-MM-DD'),'SA_REP',10500,0.25,147,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Danielle','Greene','DGREENE','011.44.1346.229268',TO_DATE('2007-03-19','YYYY-MM-DD'),'SA_REP',9500,0.15,147,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Mattea','Marvins','MMARVINS','011.44.1346.329268',TO_DATE('2008-01-24','YYYY-MM-DD'),'SA_REP',7200,0.1,147,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'David','Lee','DLEE','011.44.1346.529268',TO_DATE('2008-02-23','YYYY-MM-DD'),'SA_REP',6800,0.1,147,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Sundar','Ande','SANDE','011.44.1346.629268',TO_DATE('2008-03-24','YYYY-MM-DD'),'SA_REP',6400,0.1,147,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Amit','Banda','ABANDA','011.44.1346.729268',TO_DATE('2008-04-21','YYYY-MM-DD'),'SA_REP',6200,0.1,147,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Lisa','Ozer','LOZER','011.44.1343.929268',TO_DATE('2005-03-11','YYYY-MM-DD'),'SA_REP',11500,0.25,148,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Harrison','Bloom','HBLOOM','011.44.1343.829268',TO_DATE('2006-03-23','YYYY-MM-DD'),'SA_REP',10000,0.2,148,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Tayler','Fox','TFOX','011.44.1343.729268',TO_DATE('2006-01-24','YYYY-MM-DD'),'SA_REP',9600,0.2,148,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'William','Smith','WSMITH','011.44.1343.629268',TO_DATE('2007-02-23','YYYY-MM-DD'),'SA_REP',7400,0.15,148,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Elizabeth','Bates','EBATES','011.44.1343.529268',TO_DATE('2007-03-24','YYYY-MM-DD'),'SA_REP',7300,0.15,148,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Sundita','Kumar','SKUMAR','011.44.1343.329268',TO_DATE('2008-04-21','YYYY-MM-DD'),'SA_REP',6100,0.1,148,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Ellen','Abel','EABEL','011.44.1644.429267',TO_DATE('2004-05-11','YYYY-MM-DD'),'SA_REP',11000,0.3,149,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Alyssa','Hutton','AHUTTON','011.44.1644.429266',TO_DATE('2005-03-19','YYYY-MM-DD'),'SA_REP',8800,0.25,149,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jonathon','Taylor','JTAYLOR','011.44.1644.429265',TO_DATE('2006-03-24','YYYY-MM-DD'),'SA_REP',8600,0.2,149,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jack','Livingston','JLIVINGS','011.44.1644.429264',TO_DATE('2006-04-23','YYYY-MM-DD'),'SA_REP',8400,0.2,149,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Kimberely','Grant','KGRANT','011.44.1644.429263',TO_DATE('2007-05-24','YYYY-MM-DD'),'SA_REP',7000,0.15,149,null);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Charles','Johnson','CJOHNSON','011.44.1644.429262',TO_DATE('2008-01-04','YYYY-MM-DD'),'SA_REP',6200,0.1,149,80);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Winston','Taylor','WTAYLOR','650.507.9876',TO_DATE('2006-01-24','YYYY-MM-DD'),'SH_CLERK',3200,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jean','Fleaur','JFLEAUR','650.507.9877',TO_DATE('2006-02-23','YYYY-MM-DD'),'SH_CLERK',3100,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Martha','Sullivan','MSULLIVA','650.507.9878',TO_DATE('2007-06-21','YYYY-MM-DD'),'SH_CLERK',2500,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Girard','Geoni','GGEONI','650.507.9879',TO_DATE('2008-02-03','YYYY-MM-DD'),'SH_CLERK',2800,null,120,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Nandita','Sarchand','NSARCHAN','650.509.1876',TO_DATE('2004-01-27','YYYY-MM-DD'),'SH_CLERK',4200,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Alexis','Bull','ABULL','650.509.2876',TO_DATE('2005-02-20','YYYY-MM-DD'),'SH_CLERK',4100,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Julia','Dellinger','JDELLING','650.509.3876',TO_DATE('2006-06-24','YYYY-MM-DD'),'SH_CLERK',3400,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Anthony','Cabrio','ACABRIO','650.509.4876',TO_DATE('2007-02-07','YYYY-MM-DD'),'SH_CLERK',3000,null,121,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Kelly','Chung','KCHUNG','650.505.1876',TO_DATE('2005-06-14','YYYY-MM-DD'),'SH_CLERK',3800,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jennifer','Dilly','JDILLY','650.505.2876',TO_DATE('2005-08-13','YYYY-MM-DD'),'SH_CLERK',3600,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Timothy','Gates','TGATES','650.505.3876',TO_DATE('2006-07-11','YYYY-MM-DD'),'SH_CLERK',2900,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Randall','Perkins','RPERKINS','650.505.4876',TO_DATE('2007-12-19','YYYY-MM-DD'),'SH_CLERK',2500,null,122,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Sarah','Bell','SBELL','650.501.1876',TO_DATE('2004-02-04','YYYY-MM-DD'),'SH_CLERK',4000,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Britney','Everett','BEVERETT','650.501.2876',TO_DATE('2005-03-03','YYYY-MM-DD'),'SH_CLERK',3900,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Samuel','McCain','SMCCAIN','650.501.3876',TO_DATE('2006-07-01','YYYY-MM-DD'),'SH_CLERK',3200,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Vance','Jones','VJONES','650.501.4876',TO_DATE('2007-03-17','YYYY-MM-DD'),'SH_CLERK',2800,null,123,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Alana','Walsh','AWALSH','650.507.9811',TO_DATE('2006-04-24','YYYY-MM-DD'),'SH_CLERK',3100,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Kevin','Feeney','KFEENEY','650.507.9822',TO_DATE('2006-05-23','YYYY-MM-DD'),'SH_CLERK',3000,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Donald','OConnell','DOCONNEL','650.507.9833',TO_DATE('2007-06-21','YYYY-MM-DD'),'SH_CLERK',2600,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Douglas','Grant','DGRANT','650.507.9844',TO_DATE('2008-01-13','YYYY-MM-DD'),'SH_CLERK',2600,null,124,50);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Jennifer','Whalen','JWHALEN','515.123.4444',TO_DATE('2003-09-17','YYYY-MM-DD'),'AD_ASST',4400,null,101,10);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Michael','Hartstein','MHARTSTE','515.123.5555',TO_DATE('2004-02-17','YYYY-MM-DD'),'MK_MAN',13000,null,100,20);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Pat','Fay','PFAY','603.123.6666',TO_DATE('2005-08-17','YYYY-MM-DD'),'MK_REP',6000,null,201,20);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Susan','Mavris','SMAVRIS','515.123.7777',TO_DATE('2002-06-07','YYYY-MM-DD'),'HR_REP',6500,null,101,40);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Hermann','Baer','HBAER','515.123.8888',TO_DATE('2002-06-07','YYYY-MM-DD'),'PR_REP',10000,null,101,70);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'Shelley','Higgins','SHIGGINS','515.123.8080',TO_DATE('2002-06-07','YYYY-MM-DD'),'AC_MGR',12008,null,101,110);
INSERT INTO EMPLOYEES4 (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) VALUES (EMPLOYEES4_SEQ.NEXTVAL,'William','Gietz','WGIETZ','515.123.8181',TO_DATE('2002-06-07','YYYY-MM-DD'),'AC_ACCOUNT',8300,null,205,110);
--○ JOB_HISTORY4 테이블 데이터 입력---------------------------------------------
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (102,TO_DATE('2001-01-13','YYYY-MM-DD'),TO_DATE('2006-07-24','YYYY-MM-DD'),'IT_PROG',60);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (101,TO_DATE('1997-09-21','YYYY-MM-DD'),TO_DATE('2001-10-27','YYYY-MM-DD'),'AC_ACCOUNT',110);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (101,TO_DATE('2001-10-28','YYYY-MM-DD'),TO_DATE('2005-03-15','YYYY-MM-DD'),'AC_MGR',110);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (201,TO_DATE('2004-02-17','YYYY-MM-DD'),TO_DATE('2007-12-19','YYYY-MM-DD'),'MK_REP',20);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (114,TO_DATE('2006-03-24','YYYY-MM-DD'),TO_DATE('2007-12-31','YYYY-MM-DD'),'ST_CLERK',50);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (122,TO_DATE('2007-01-01','YYYY-MM-DD'),TO_DATE('2007-12-31','YYYY-MM-DD'),'ST_CLERK',50);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (200,TO_DATE('1995-09-17','YYYY-MM-DD'),TO_DATE('2001-06-17','YYYY-MM-DD'),'AD_ASST',90);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (176,TO_DATE('2006-03-24','YYYY-MM-DD'),TO_DATE('2006-12-31','YYYY-MM-DD'),'SA_REP',80);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (176,TO_DATE('2007-01-01','YYYY-MM-DD'),TO_DATE('2007-12-31','YYYY-MM-DD'),'SA_MAN',80);
INSERT INTO JOB_HISTORY4 (EMPLOYEE_ID,START_DATE,END_DATE,JOB_ID,DEPARTMENT_ID) VALUES (200,TO_DATE('2002-07-01','YYYY-MM-DD'),TO_DATE('2006-12-31','YYYY-MM-DD'),'AC_ACCOUNT',90);
--[확인]========================================================================
SELECT *
FROM REGIONS4;
--==>>
/*
============================================
REGION_ID REGION_NAME
============================================
1 Europe
2 Americas
3 Asia
4 Middle East and Africa
============================================
*/
SELECT *
FROM COUNTRIES4;
--==>>
/*
====================================================
COUNTRY_ID COUNTRY_NAME REGION_ID
====================================================
AR Argentina 2
AU Australia 3
BE Belgium 1
BR Brazil 2
CA Canada 2
CH Switzerland 1
CN China 3
DE Germany 1
DK Denmark 1
EG Egypt 4
FR France 1
IL Israel 4
IN India 3
IT Italy 1
JP Japan 3
KW Kuwait 4
ML Malaysia 3
MX Mexico 2
NG Nigeria 4
NL Netherlands 1
SG Singapore 3
UK United Kingdom 1
US United States of America 2
ZM Zambia 4
ZW Zimbabwe 4
====================================================
*/
SELECT *
FROM LOCATIONS4;
/*
============================================================================================================================
LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY_ID
============================================================================================================================
1000 1297 Via Cola di Rie 00989 Roma (null) IT
1100 93091 Calle della Testa 10934 Venice (null) IT
1200 2017 Shinjuku-ku 1689 Tokyo Tokyo Prefecture JP
1300 9450 Kamiya-cho 6823 Hiroshima (null) JP
1400 2014 Jabberwocky Rd 26192 Southlake Texas US
1500 2011 Interiors Blvd 99236 South San Francisco California US
1600 2007 Zagora St 50090 South Brunswick New Jersey US
1700 2004 Charade Rd 98199 Seattle Washington US
1800 147 Spadina Ave M5V 2L7 Toronto Ontario CA
1900 6092 Boxwood St YSW 9T2 Whitehorse Yukon CA
2000 40-5-12 Laogianggen 190518 Beijing (null) CN
2100 1298 Vileparle (E) 490231 Bombay Maharashtra IN
2200 12-98 Victoria Street 2901 Sydney New South Wales AU
2300 198 Clementi North 540198 Singapore (null) SG
2400 8204 Arthur St (null) London (null) UK
2500 Magdalen Centre, The Oxford Science Park OX9 9ZB Oxford Oxford UK
2600 9702 Chester Road 09629850293 Stretford Manchester UK
2700 Schwanthalerstr. 7031 80925 Munich Bavaria DE
2800 Rua Frei Caneca 1360 01307-002 Sao Paulo Sao Paulo BR
2900 20 Rue des Corps-Saints 1730 Geneva Geneve CH
3000 Murtenstrasse 921 3095 Bern BE CH
3100 Pieter Breughelstraat 837 3029SK Utrecht Utrecht NL
3200 Mariano Escobedo 9991 11932 Mexico City Distrito Federal, MX
============================================================================================================================
*/
SELECT *
FROM DEPARTMENTS4;
--==>>
/*
=========================================================================
DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
=========================================================================
10 Administration 200 1700
20 Marketing 201 1800
30 Purchasing 114 1700
40 Human Resources 203 2400
50 Shipping 121 1500
60 IT 103 1400
70 Public Relations 204 2700
80 Sales 145 2500
90 Executive 100 1700
100 Finance 108 1700
110 Accounting 205 1700
120 Treasury (null) 1700
130 Corporate Tax (null) 1700
140 Control And Credit (null) 1700
150 Shareholder Services (null) 1700
160 Benefits (null) 1700
170 Manufacturing (null) 1700
180 Construction (null) 1700
190 Contracting (null) 1700
200 Operations (null) 1700
210 IT Support (null) 1700
220 NOC (null) 1700
230 IT Helpdesk (null) 1700
240 Government Sales (null) 1700
250 Retail Sales (null) 1700
260 Recruiting (null) 1700
270 Payroll (null) 1700
=========================================================================
*/
SELECT *
FROM JOBS4;
--==>>
/*
=========================================================================
JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY
=========================================================================
AD_PRES President 20080 40000
AD_VP Administration Vice President 15000 30000
AD_ASST Administration Assistant 3000 6000
FI_MGR Finance Manager 8200 16000
FI_ACCOUNT Accountant 4200 9000
AC_MGR Accounting Manager 8200 16000
AC_ACCOUNT Public Accountant 4200 9000
SA_MAN Sales Manager 10000 20080
SA_REP Sales Representative 6000 12008
PU_MAN Purchasing Manager 8000 15000
PU_CLERK Purchasing Clerk 2500 5500
ST_MAN Stock Manager 5500 8500
ST_CLERK Stock Clerk 2008 5000
SH_CLERK Shipping Clerk 2500 5500
IT_PROG Programmer 4000 10000
MK_MAN Marketing Manager 9000 15000
MK_REP Marketing Representative 4000 9000
HR_REP Human Resources Representative 4000 9000
PR_REP Public Relations Representative 4500 10500
=========================================================================
*/
SELECT *
FROM EMPLOYEES4;
--==>>
/*
=====================================================================================================================================================
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
=====================================================================================================================================================
100 Steven King SKING 515.123.4567 2003-06-17 AD_PRES 24000 (null) (null) 90
101 Neena Kochhar NKOCHHAR 515.123.4568 2005-09-21 AD_VP 17000 (null) 100 90
102 Lex De Haan LDEHAAN 515.123.4569 2001-01-13 AD_VP 17000 (null) 100 90
103 Alexander Hunold AHUNOLD 590.423.4567 2006-01-03 IT_PROG 9000 (null) 102 60
104 Bruce Ernst BERNST 590.423.4568 2007-05-21 IT_PROG 6000 (null) 103 60
105 David Austin DAUSTIN 590.423.4569 2005-06-25 IT_PROG 4800 (null) 103 60
106 Valli Pataballa VPATABAL 590.423.4560 2006-02-05 IT_PROG 4800 (null) 103 60
107 Diana Lorentz DLORENTZ 590.423.5567 2007-02-07 IT_PROG 4200 (null) 103 60
108 Nancy Greenberg NGREENBE 515.124.4569 2002-08-17 FI_MGR 12008 (null) 101 100
109 Daniel Faviet DFAVIET 515.124.4169 2002-08-16 FI_ACCOUNT 9000 (null) 108 100
110 John Chen JCHEN 515.124.4269 2005-09-28 FI_ACCOUNT 8200 (null) 108 100
111 Ismael Sciarra ISCIARRA 515.124.4369 2005-09-30 FI_ACCOUNT 7700 (null) 108 100
112 Jose Manuel Urman JMURMAN 515.124.4469 2006-03-07 FI_ACCOUNT 7800 (null) 108 100
113 Luis Popp LPOPP 515.124.4567 2007-12-07 FI_ACCOUNT 6900 (null) 108 100
114 Den Raphaely DRAPHEAL 515.127.4561 2002-12-07 PU_MAN 11000 (null) 100 30
115 Alexander Khoo AKHOO 515.127.4562 2003-05-18 PU_CLERK 3100 (null) 114 30
116 Shelli Baida SBAIDA 515.127.4563 2005-12-24 PU_CLERK 2900 (null) 114 30
117 Sigal Tobias STOBIAS 515.127.4564 2005-07-24 PU_CLERK 2800 (null) 114 30
118 Guy Himuro GHIMURO 515.127.4565 2006-11-15 PU_CLERK 2600 (null) 114 30
119 Karen Colmenares KCOLMENA 515.127.4566 2007-08-10 PU_CLERK 2500 (null) 114 30
120 Matthew Weiss MWEISS 650.123.1234 2004-07-18 ST_MAN 8000 (null) 100 50
121 Adam Fripp AFRIPP 650.123.2234 2005-04-10 ST_MAN 8200 (null) 100 50
122 Payam Kaufling PKAUFLIN 650.123.3234 2003-05-01 ST_MAN 7900 (null) 100 50
123 Shanta Vollman SVOLLMAN 650.123.4234 2005-10-10 ST_MAN 6500 (null) 100 50
124 Kevin Mourgos KMOURGOS 650.123.5234 2007-11-16 ST_MAN 5800 (null) 100 50
125 Julia Nayer JNAYER 650.124.1214 2005-07-16 ST_CLERK 3200 (null) 120 50
126 Irene Mikkilineni IMIKKILI 650.124.1224 2006-09-28 ST_CLERK 2700 (null) 120 50
127 James Landry JLANDRY 650.124.1334 2007-01-14 ST_CLERK 2400 (null) 120 50
128 Steven Markle SMARKLE 650.124.1434 2008-03-08 ST_CLERK 2200 (null) 120 50
129 Laura Bissot LBISSOT 650.124.5234 2005-08-20 ST_CLERK 3300 (null) 121 50
130 Mozhe Atkinson MATKINSO 650.124.6234 2005-10-30 ST_CLERK 2800 (null) 121 50
131 James Marlow JAMRLOW 650.124.7234 2005-02-16 ST_CLERK 2500 (null) 121 50
132 TJ Olson TJOLSON 650.124.8234 2007-04-10 ST_CLERK 2100 (null) 121 50
133 Jason Mallin JMALLIN 650.127.1934 2004-06-14 ST_CLERK 3300 (null) 122 50
134 Michael Rogers MROGERS 650.127.1834 2006-08-26 ST_CLERK 2900 (null) 122 50
135 Ki Gee KGEE 650.127.1734 2007-12-12 ST_CLERK 2400 (null) 122 50
136 Hazel Philtanker HPHILTAN 650.127.1634 2008-02-06 ST_CLERK 2200 (null) 122 50
137 Renske Ladwig RLADWIG 650.121.1234 2003-07-14 ST_CLERK 3600 (null) 123 50
138 Stephen Stiles SSTILES 650.121.2034 2005-10-26 ST_CLERK 3200 (null) 123 50
139 John Seo JSEO 650.121.2019 2006-02-12 ST_CLERK 2700 (null) 123 50
140 Joshua Patel JPATEL 650.121.1834 2006-04-06 ST_CLERK 2500 (null) 123 50
: : : : : : : : : : :
205 Shelley Higgins SHIGGINS 515.123.8080 2002-06-07 AC_MGR 12008 (null) 101 110
206 William Gietz WGIETZ 515.123.8181 2002-06-07 AC_ACCOUNT 8300 (null) 205 110
=====================================================================================================================================================
*/
SELECT *
FROM JOB_HISTORY4;
--==>>
/*
=======================================================================
EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMENT_ID
=======================================================================
102 2001-01-13 2006-07-24 IT_PROG 60
101 1997-09-21 2001-10-27 AC_ACCOUNT 110
101 2001-10-28 2005-03-15 AC_MGR 110
201 2004-02-17 2007-12-19 MK_REP 20
114 2006-03-24 2007-12-31 ST_CLERK 50
122 2007-01-01 2007-12-31 ST_CLERK 50
200 1995-09-17 2001-06-17 AD_ASST 90
176 2006-03-24 2006-12-31 SA_REP 80
176 2007-01-01 2007-12-31 SA_MAN 80
200 2002-07-01 2006-12-31 AC_ACCOUNT 90
=======================================================================
*/
--==============================================================================
--[테이블 삭제]==================================================================
--DROP TABLE REGIONS4;
--DROP TABLE COUNTRIES4;
--DROP TABLE LOCATIONS4;
--DROP TABLE DEPARTMENTS4;
--DROP TABLE JOBS4;
--DROP TABLE EMPLOYEES4;
--○ 매니저 ID FOREIGN KEY 삭제. (EMPLOYEES4의 EMPLOYEE_ID를 참조하므로 우선 삭제)
--ALTER TABLE DEPARTMENTS4
--DROP CONSTRAINT DEPT4_MGR_FK;
--DROP TABLE JOB_HISTORY4;
--[시퀀스 생성]==================================================================
CREATE SEQUENCE DEPARTMENTS4_SEQ
START WITH 10
INCREMENT BY 10
MAXVALUE 9990
NOCACHE;
CREATE SEQUENCE EMPLOYEES4_SEQ
START WITH 100
INCREMENT BY 1
NOMAXVALUE
NOCACHE;
CREATE SEQUENCE LOCATIONS4_SEQ
START WITH 1000
INCREMENT BY 100
MAXVALUE 9900
NOCACHE;
--○ 시퀀스 삭제
--DROP SEQUENCE DEPARTMENTS4_SEQ;
--DROP SEQUENCE EMPLOYEES4_SEQ;
--DROP SEQUENCE LOCATIONS4_SEQ;
--==============================================================================
'[Oracle] > SQL (Program source)' 카테고리의 다른 글
| [Oracle] 20231101 [프로그램 소스] (0) | 2023.11.01 |
|---|---|
| [Oracle] 20231031 [프로그램소스] - 20231031_01_HR (0) | 2023.11.01 |
| [Oracle] 20231030 [프로그램소스] - 20231030_01_HR, TBL_INSA(중간 수행평가) (0) | 2023.10.30 |
| [Oracle] 20231027 [프로그램소스] - 20231027_01_SCOTT, TBL_INSA(중간 수행평가) (0) | 2023.10.27 |
| [Oracle] 20231026 [프로그램소스] - 231026_01_SCOTT, 231026_02_HR, 231026_03_SCOTT (0) | 2023.10.26 |