   CONSTRAINT FK_MEASURES FOREIGN KEY (MEASURE_ID) REFERENCES MEASURE_UNITS(M_ID)
 );
 
+--DROP SEQUENCE PROD_SEQ;
+--DROP TRIGGER TRIG_PROD;
+--TRUNCATE TABLE PRODUCTS;
+
 CREATE SEQUENCE PROD_SEQ
 MINVALUE 1
 START WITH 1

    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (100, 'Yoghurt 0.1% 450g', 200, 0.90, 'food')  
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (190, 'Head ' || chr(38) || ' Shoulders', 200, 5.35, 'body care')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (140, 'Happy Day 100% Orange 1l', 200, 2.30, 'non-alcohol drinks')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (10, 'Heinz Tomato Ketchup', 200, 4.80, 'food')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (200, 'NIVEA honey ' || chr(38) || ' oil soap', 200, 0.90, 'body care')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (180, 'Natural Elements Red Fruits soap 100g', 200, 0.99, 'body care')            
    SELECT * FROM dual  
    COMMIT;
EXCEPTION

    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (90, 'Ovcho Narodno cheese', 300, 8.40, 'food')         
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (180, 'Aroma Vital Exfoliating soap 100g', 200, 0.99, 'body_care')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (170, 'Devin Mineral Water 10l', 100, 3.99, 'non-alcohol_drinks')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (170, 'Devin Mineral Water 1.5l', 100, 0.85, 'non-alcohol_drinks')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (110, 'JOHNSONS baby HEAD-TO-TOE wash shampoo 444ml', 
                    200, 3.15, 'body_care')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (110, 'JOHNSONS baby moisture wash with honey apple shampoo 444ml', 
                    200, 3.15, 'body_care')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
          VALUES  (210, 'Costa d`Oro 1l', 200, 13.59, 'food')
    INTO PRODUCTS (VENDOR_ID, PRODUCT_NAME, MEASURE_ID, PRICE, PRODUCT_TYPE) 
