相关代码 |
|
drop table RECORDINGS; drop sequence RECORDINGS_SEQ; create table RECORDINGS ( RECORDING_ID INT not null, RECORDING_TITLE VARCHAR2(50) not null, RECORDING_ARTIST VARCHAR2(50) not null, CATALOG_NUMBER VARCHAR2(20) not null, LIST_PRICE DECIMAL(7,2) not null, VERSION INT not null, constraint RECORDINGS_PK primary key (RECORDING_ID) ); create sequence RECORDINGS_SEQ;