Yurttas/PL/DBL/oracle/F/01/Company-A/Employee-def.sql
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));