Yurttas/PL/DBL/oracle/F/01/PC/PC-def.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM PC-def.sql
 4REM
 5REM
 6
 7CREATE TABLE PC(model VARCHAR2(6) NOT NULL,
 8                speed NUMBER(4) NOT NULL,
 9                ram NUMBER(2) NOT NULL,
10                hd NUMBER(3,1) NOT NULL,
11                cd VARCHAR2(4) NOT NULL,
12                price NUMBER(4) NOT NULL,
13   PRIMARY KEY (model));