Yurttas/PL/DBL/oracle/F/01/PC/PC-def.sql
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));