table games.txt

来自「codding for pszone one can use it at pl」· 文本 代码 · 共 11 行

CREATE TABLE GAMES(CODE_NO NUMBER NOT NULL PRIMARY KEY,GAME_NAME VARCHAR2(20) NOT NULL,QTY_AVAILABLE NUMBER NOT NULL,STOCK_FOR_PSZone NUMBER);
INSERT INTO GAMES VALUES(1,'POPEYE_THE_SAILERMAN',4,2);
INSERT INTO GAMES VALUES(2,'CS_CONDITION_ZERO',7,2);
INSERT INTO GAMES VALUES(3,'NFS_UNDERGROUND2',10,2);
INSERT INTO GAMES VALUES(4,'NFS_MOST_WANTED',12,2);
INSERT INTO GAMES VALUES(5,'WWE_RAW_VS_SMACK_06',5,2);
INSERT INTO GAMES VALUES(6,'CRICKET_2006',7,2);
INSERT INTO GAMES VALUES(7,'FIFA_2006',10,2);
INSERT INTO GAMES VALUES(8,'HALF_LIFE_2',8,2);
INSERT INTO GAMES VALUES(9,'CALL_OF_DUTY',6,2);
INSERT INTO GAMES VALUES(10,'GTA_SAN_ANDREAS',12,2);