rem 
rem $Header: instrucs.sql,v 1.1 1993/08/11 10:06:13 RKOOI2 Exp $ 
rem 
Rem  Copyright (c) 1993 by Oracle Corporation 
Rem    NAME
Rem      instrucs.sql - <one-line expansion of the name>
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     rkooi2     08/11/93 -  Creation 
DELETE FROM instructors;

REM Add some faculty to the college

INSERT INTO instructors VALUES (
        'Webster', 'Milo', 'B',
        9000,
        '01-SEP-49',
        140,
        40000,
        'PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Crown', 'Edgar', 'G',
        9001,
        '03-SEP-70',
        150,
        35000,
        'PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Golighty', 'Claire', 'M',
        9002,
        '24-AUG-82',
        120,
        33000,
        'ASSISTANT PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Winterby', 'Hugh', '',
        9003,
        '10-SEP-82',
        120,
        43000,
        'PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Whipplethorpe', 'Francis', 'X',
        9004,
        '01-SEP-78',
        170,
        50000,
        'PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Shillingsworth', 'Susan', 'G',
        9005,
        '22-AUG-87',
        160,
        65000,
        'PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Herringbone', 'Leo', 'R',
        9006,
        '02-JAN-81',
        110,
        40000,
        'ASSOCIATE PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Willowbough', 'George', 'T',
        9007,
        '04-SEP-86',
        180,
        37000,
        'ASSOCIATE PROFESSOR'
        );

INSERT INTO instructors VALUES (
        'Higham', 'Earnest', 'V',
        9008,
        '10-JUN-76',
        100,
        55000,
        'PROFESSOR'
        );








