Trigger to update a date column value after the insert on the same row Oracle 11g
Posted on 2014-09-19
I need some help with trigger to update a date column value if it is blank after the insert of row on a table
Table : ASSET_LN
ASSET_ID (Key Field)
I have a application where values are comming from external source, all values are provided by source system except pay date. So I need a trigger to default paydate to asset date when a row is inserted into ASSET_LN .
PAY_DATE update need to happen at the same time when a new row is inserted.
Thanks for your help in advance.