CUSTOMER_TBL

CREATE TABLE CUSTOMER_TBL
}
CUST_ID             VARCHAR2(10)    NOT NULL      PRIMARYKEY,
CUST_NAME           VARCHAR2(30)    NOT NULL,
CUST_ADDRESS        VARCHAR2(20)    NOT NULL,
CUST_CITY           VARCHAR2(15)    NOT NULL,
CUST_STATE          CHAR(2)         NOT NULL,
CUST_ZIP            NUMBER(5)       NOT NULL,
CUST_PHONE          NUMBER(10),
CUST_FAX            NUMBER(10),
}
/

Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.