View difference between Paste ID: DXiYy9ca and eAvxupiK

 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,
+     ("PRODUCT_NAME" varchar2(20), "PROCESS1" int, "PROCESS2" int, "WEIGHT" int,
-     ("PROCESS1" + "PROCESS2")*"WEIGHT" as "TOTAL_WEIGHT",
+     "TOTAL_WEIGHT"  number generated always as ("PROCESS1" + "PROCESS2")*"WEIGHT",
-     "RECORDED_DATE" date)
+     "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'))
-		 VALUES ('ITEM1', 0, 0, 10, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
+
          "RECORDED_DATE")
         VALUES ('ITEM2', 1, 1, 10, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
-         VALUES ('ITEM2', 1, 1, 10, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
+
          "RECORDED_DATE")
         VALUES ('ITEM3', 1, 1, 15, TO_DATE('01-JAN-2014','DD-MON-YYYY'));
-         VALUES ('ITEM3', 1, 1, 15, TO_DATE('01-JAN-2014','DD-MON-YYYY'))
+
-//
+
          "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
-         VALUES ('ITEM2', 3, 1, 10, TO_DATE('14-FEB-2014','DD-MON-YYYY'))
+
-//
+
          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 ('ITEM1', 2, 5, 55, TO_DATE('14-MAR-2014','DD-MON-YYYY'))
+		 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
-		 VALUES ('ITEM3', 2, 1, 20, TO_DATE('01-APR-2014','DD-MON-YYYY'))
+