so-virtual-column-testing

Stack Overflow Test PLAN FOR:
http://stackoverflow.com/questions/24276153/oracle-pl-sql-with-automatic-VALUES
(prepared BY Richard Pascual)


CREATE TABLE PROCESSED_PRODUCT_WEIGHT
    ("PRODUCT_NAME" VARCHAR2(20), "PROCESS1" int, "PROCESS2" int, "WEIGHT" int,
     ("PROCESS1" + "PROCESS2")*"WEIGHT" AS "TOTAL_WEIGHT",
     "RECORDED_DATE" DATE)
//

INSERT ALL
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT",
         "RECORDED_DATE")
         VALUES ('ITEM1', 0, 0, 10, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT",
         "RECORDED_DATE")
         VALUES ('ITEM2', 1, 1, 10, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT",
         "RECORDED_DATE")
         VALUES ('ITEM3', 1, 1, 15, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
//
INSERT ALL
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT",
         "RECORDED_DATE")
         VALUES ('ITEM1', 2, 5, 10, TO_DATE('14-FEB-2014','DD-MON-YYYY'))
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT",
         "RECORDED_DATE")
         VALUES ('ITEM2', 3, 1, 10, TO_DATE('14-FEB-2014','DD-MON-YYYY'))
//
INSERT ALL
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT",
         "RECORDED_DATE")
         VALUES ('ITEM1', 2, 5, 55, TO_DATE('14-MAR-2014','DD-MON-YYYY'))
//
INSERT ALL
    INTO PROCESSED_PRODUCT_WEIGHT ("PRODUCT_NAME", "PROCESS1", "PROCESS2", "WEIGHT")
         VALUES ('ITEM3', 2, 1, 20, TO_DATE('01-APR-2014','DD-MON-YYYY'))
//
SELECT * FROM PROCESSED_PRODUCT_WEIGHT
ORDER BY RECORDED_DATE ASC, PRODUCT_NAME ASC
//