/* Database Systems, Coronel/Morris */
/* Type of SQL : Oracle */

ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';

CREATE TABLE PRODMASTER (
PROD_ID varchar(50) PRIMARY KEY,
PROD_DESC varchar(50),
PROD_QOH integer
);
INSERT INTO PRODMASTER VALUES('A123','SCREWS','67');
INSERT INTO PRODMASTER VALUES('BX34','NUTS','37');
INSERT INTO PRODMASTER VALUES('C583','BOLTS','50');

/* -- */

CREATE TABLE PRODSALES (
PROD_ID varchar(50) PRIMARY KEY,
PS_QTY integer
);
INSERT INTO PRODSALES VALUES('A123','7');
INSERT INTO PRODSALES VALUES('BX34','3');
