REM
REM Creating and Populating the Sample JOB_TITLES Table for Chapters 5-7
REM Oracle 7.3 Version
REM
PROMPT
PROMPT Creating Sample JOB_TITLES table
PROMPT
Create Table JOB_TITLES(
  JOB_TITLE_CODE	NUMBER(10) NOT NULL,
  JOB_TITLE		VARCHAR2(100) 
 )
;

INSERT INTO JOB_TITLES
   (JOB_TITLE_CODE , JOB_TITLE )
VALUES 
   (141955 , 'Associate Director, Computer Science')
;

INSERT INTO JOB_TITLES
   (JOB_TITLE_CODE , JOB_TITLE )
VALUES 
   (130891 , 'Professor of Computer Science')
;

INSERT INTO JOB_TITLES
   (JOB_TITLE_CODE , JOB_TITLE )
VALUES 
   (110689 , 'Head, Department of Computer Science')
;

INSERT INTO JOB_TITLES
   (JOB_TITLE_CODE , JOB_TITLE )
VALUES 
   (132955 , 'Instructor, Computer Science')
;

