table pszone_members.txt

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

CREATE TABLE PSZONE_MEMBERS(CUSTOMER_NO NUMBER NOT NULL PRIMARY KEY,NAME VARCHAR2(15) NOT NULL,ADDRESS VARCHAR2(25) NOT NULL,GENDER_M_F VARCHAR2(10) NOT NULL,DATE_OF_BIRTH DATE NOT NULL,SUBSCRIPTION_DATE DATE NOT NULL,BALANCE NUMBER);
INSERT INTO PSZONE_MEMBERS VALUES(2101,'TOMMY','OXFORD GUGO STREET,19','M','21-MAY-90','02-AUG-04',1900);
INSERT INTO PSZONE_MEMBERS VALUES(2102,'CALVIN','MALBOURNE LULO STREET,02','M','05-OCT-93','21-AUG-05',1750);
INSERT INTO PSZONE_MEMBERS VALUES(2103,'ARMAAN','CAMBRIDGE JUJO STREET,05','M','16-JAN-88','08-OCT-01',1800);
INSERT INTO PSZONE_MEMBERS VALUES(2104,'VASUNDRA','TEXAS MUMO STREET,08','F','30-APR-92','22-FEB-00',1550);
INSERT INTO PSZONE_MEMBERS VALUES(2105,'GHAJODAR','XAVIORS HUHO STREET,43','M','12-JUN-94','27-JUL-05',1600);
INSERT INTO PSZONE_MEMBERS VALUES(2106,'VINOD','SIMBYOSIS SUSO STREET,34','M','31-JUL-90','17-NOV-98',2000);
INSERT INTO PSZONE_MEMBERS VALUES(2107,'GOPAL','RAMRAM TUTO STREET,22','M','18-MAR-85','25-DEC-97',950);