PROMPT Building vendors table ...
DROP TABLE vendor;
CREATE TABLE vendor
(vendor_id NUMBER(6)      PRIMARY KEY,
vendor_name VARCHAR2(40),
v_phone VARCHAR2(14),
v_addr1 VARCHAR2(30),
v_addr2 VARCHAR2(30),
v_city VARCHAR2(25),
v_state VARCHAR2(2),
v_zip VARCHAR2(5),
v_fax VARCHAR2(14),
v_contact VARCHAR2(40),
v_catalog VARCHAR2(1) );

PROMPT  Inserting Vendor records ...
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6001, 'TIRES R US','VA','Y');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6002, 'GOODYEAR TIRE COMPANY','MD','N');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6003, 'TIRE Rack','PA','Y');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6004, 'JOE FILTERS','DC','N');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6005, 'COSTCO FLOOR MATS','VA','Y');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6006, 'SAM''S TIRES','MD','Y');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6007, 'INTERSTATE Batteries','DC','N');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6008, 'QUAKER MOTOR OIL','PA','Y');
INSERT INTO VENDOR(vendor_id, vendor_name, v_state, v_catalog)
VALUES
(6009, 'PENZOIL MOTOR OIL','PA','N');
COMMIT;
/