Yurttas/PL/DBL/oracle/F/01/Company-B/Manages-def.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM Manages-def.sql
 4REM
 5REM
 6
 7CREATE TABLE Manages (employeename VARCHAR2(16) NOT NULL,
 8                      managername VARCHAR2(16),
 9         PRIMARY KEY (employeename),
10         FOREIGN KEY (employeename) REFERENCES Employee(employeename),
11         FOREIGN KEY (managername) REFERENCES Employee(employeename));