ORDERS_TBL

CREATE TABLE ORDERS_TBL
{
ORD_NUM             VARCHAR2(10)    NOT NULL     PRIMARYKEY,
CUST_ID             VARCHAR2(10)    NOT NULL,
PROD_ID             VARCHAR2(10)    NOT NULL,
QTY                 NUMBER(6)       NOT NULL,
ORD_DATE            DATE,
}
/

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.