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

From ZCubes Wiki
Revision as of 22:54, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM REM Employee-def.sql REM REM CREATE TABLE Employee(fname VARCHAR2(12) NOT NULL, minit ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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));