Yurttas/PL/DBL/oracle/F/01/Company-A/Employee-def.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM Employee-def.sql
 4REM
 5REM
 6
 7CREATE TABLE Employee(fname VARCHAR2(12) NOT NULL,
 8                      minit CHAR,
 9                      lname VARCHAR2(16) NOT NULL, 
10                      ssn CHAR(9) NOT NULL,
11                      bdate CHAR(9),
12                      address VARCHAR2(24),
13                      sex CHAR,
14                      salary NUMBER(8,2),
15                      superssn CHAR(9),
16                      dno INTEGER NOT NULL,
17          PRIMARY KEY(ssn));