CREATE TABLE ITEM_MASTER (
ITNO NUMBER(4) PRIMARY KEY,
NAME VARCHAR2(20) NOT NULL,
QOH NUMBER(5) DEFAULT 100,
CLASS VARCHAR2(1) NOT NULL CHECK (CLASS IN ('A','B','C')),
UOM VARCHAR2(4),
ROL NUMBER(5),
ROQ NUMBER(5),
RATE NUMBER(8,2) NOT NULL
);





INSERT INTO ITEM_MASTER VALUES (1090,'Hammer',234,'A','pcs',12,34,400.90);
INSERT INTO ITEM_MASTER VALUES (1089,'Saw',456,'B','pcs',17,23,800.89);
INSERT INTO ITEM_MASTER VALUES (1088,'Lawn Mover',123,'C','pcs',21,21,5000.88);
INSERT INTO ITEM_MASTER VALUES (1087,'Dish Washer',234,'A','pcs',76,45,950.87);
INSERT INTO ITEM_MASTER VALUES (1067,'Baking Oven',145,'A','pcs',87,34,6000.67);
INSERT INTO ITEM_MASTER VALUES (1063,'Spark Plug',150,'C','watt',34,67,750.63);
INSERT INTO ITEM_MASTER VALUES (1609,'Alternator',168,'B','watt',50,56,750.09);
INSERT INTO ITEM_MASTER VALUES (1890,'Battery',189,'A','volt',30,40,300.90);
INSERT INTO ITEM_MASTER VALUES (1378,'Piston',234,'B','pcs',45,50,250.78);