Yurttas/PL/DBL/oracle/F/01/Company-A/DeptLocation-def.sql
Jump to navigation
Jump to search
1REM
2REM
3REM DeptLocation-def.sql
4REM
5REM
6
7CREATE TABLE DeptLocation(dnumber INTEGER NOT NULL,
8 dlocation VARCHAR2(24) NOT NULL,
9 PRIMARY KEY(dnumber, dlocation),
10 FOREIGN KEY(dnumber) REFERENCES Department(dnumber));