REM
REM Creating and Populating the Sample Temporal POSITIONS Table for Chapters 5-7
REM Oracle 7.3 Version
REM

REM Drop POSITIONS if already exists
DROP Table POSITIONS;


Create Table POSITIONS(
  PCN		  VARCHAR2(6) NOT NULL,
  JOB_TITLE_CODE1 NUMBER(10),
  START_DATE      DATE,
  END_DATE        DATE
 )
;

INSERT INTO POSITIONS
   (PCN, JOB_TITLE_CODE1,START_DATE,END_DATE)
VALUES 
   ('900225', 110689 , TO_DATE('1995-07-01','YYYY-MM-DD'), TO_DATE('1998-03-01', 'YYYY-MM-DD'))
;

INSERT INTO POSITIONS
   (PCN, JOB_TITLE_CODE1,START_DATE,END_DATE)
VALUES 
   ('137112', 130891 , TO_DATE('1995-01-01','YYYY-MM-DD'), TO_DATE('3000-01-01', 'YYYY-MM-DD'))
;

INSERT INTO POSITIONS
   (PCN, JOB_TITLE_CODE1,START_DATE,END_DATE)
VALUES 
   ('999071', 141955 , TO_DATE('1994-01-01','YYYY-MM-DD'), TO_DATE('3000-01-01', 'YYYY-MM-DD'))
;

INSERT INTO POSITIONS
   (PCN, JOB_TITLE_CODE1,START_DATE,END_DATE)
VALUES 
   ('120013', 132955 , TO_DATE('1993-01-01','YYYY-MM-DD'), TO_DATE('3000-01-01', 'YYYY-MM-DD'))
;

