CONNECT TO SAMPLE;
--SET CURRENT SCHEMA = '????????';
--
--DROP TABLE TEMP;
--COMMIT;
--
  CREATE TABLE TEMP
    ( EMPNO CHAR(6) NOT NULL PRIMARY KEY
    , FIRSTNME VARCHAR(12) NOT NULL
    , LASTNAME VARCHAR(15) NOT NULL
    , WORKDEPT CHAR(3)
    , STARTDATE DATE
    , SEX CHAR(1)
    , HRLY_RATE DECIMAL(7,2)
    , HRS_WORKED INTEGER );
  COMMIT;
--
  INSERT INTO TEMP
    ( EMPNO
    , FIRSTNME
    , LASTNAME
    , WORKDEPT
    , STARTDATE
    , SEX
    , HRLY_RATE
    , HRS_WORKED )
  VALUES ('TEMP01','JOE'  ,'JONES','D11','1998-12-8','M', 30.,2080)
       , ('TEMP02','JANE' ,'DOE'  ,'D21','1995-8-1' ,'F',150., 720)
       , ('TEMP03','BETTY','SMITH','D11','1996-2-29','F', 35., 820);
  COMMIT;
--
  CONNECT RESET;