DROP TABLE INVENTORY;

CREATE TABLE INVENTORY
       (PARTNO NUMBER(5) NOT NULL,
        DESCRIPTION VARCHAR2(24),
        QONHAND NUMBER(5));

INSERT INTO INVENTORY VALUES
        (207,'GEAR',75);
INSERT INTO INVENTORY VALUES
        (209,'CAM',50);
INSERT INTO INVENTORY VALUES
        (221,'BOLT',650);
INSERT INTO INVENTORY VALUES
        (222,'BOLT',1250);
INSERT INTO INVENTORY VALUES
	(231,'NUT',700);
INSERT INTO INVENTORY VALUES
	(232,'NUT',1100);
INSERT INTO INVENTORY VALUES
	(241,'WASHER',6000);
INSERT INTO INVENTORY VALUES
	(285,'WHEEL',350);
INSERT INTO INVENTORY VALUES
	(295,'BELT',85);
INSERT INTO INVENTORY VALUES
	(305,'WHEEL',3000);
INSERT INTO INVENTORY VALUES
	(310,'TIRE',4000);