Yurttas/PL/DBL/oracle/F/01/SPJ/Shipments-def.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM Shipments-def.sql
 4REM
 5REM
 6
 7CREATE TABLE Shipments(sn VARCHAR2(4) NOT NULL,
 8                       pn VARCHAR2(4) NOT NULL,
 9                       jn VARCHAR2(4) NOT NULL,
10                       quantity INTEGER,
11           PRIMARY KEY(sn,pn,jn));