Yurttas/PL/DBL/oracle/F/01/Movie/Studio-def.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM Studio-def.sql
 4REM
 5REM
 6
 7CREATE TABLE Studio(name VARCHAR2(36) NOT NULL,
 8                    address VARCHAR2(24),
 9                    prescn NUMBER(4) NOT NULL,
10        PRIMARY KEY(name),
11        FOREIGN KEY(prescn) REFERENCES MovieExec(cn));