Differences

This shows you the differences between two versions of the page.

db2-to-oracle:new_reference_in_trigger [September 23, 2013 6:18 am]
sqlines
db2-to-oracle:new_reference_in_trigger [September 23, 2013 6:19 am] (current)
sqlines
Line 6: Line 6:
| NEW.//column// | :NEW.//column// in the trigger body | NEW.//column// in WHEN condition {{:exclamation.png|}}  | | NEW.//column// | :NEW.//column// in the trigger body | NEW.//column// in WHEN condition {{:exclamation.png|}}  |
| NEW can be omitted in assignment | :NEW must be specified in assignment {{:exclamation.png|}} || | NEW can be omitted in assignment | :NEW must be specified in assignment {{:exclamation.png|}} ||
 +
 +**Note:** DB2 and Oracle allow you to change alias NEW to any other identifier using REFERENCING NEW AS //name// clause.
===== NEW Can be Skipped in DB2, but Required in Oracle ===== ===== NEW Can be Skipped in DB2, but Required in Oracle =====