I have a table to which I have added two columns.
One is last_modified_date and the other is update_flag.
I need a trigger here which performs the following:
1) When a new record is inserted into the table, sysdate is moved into the last_modified_date col.
2) WHen a record is updated, the update_flag is set to 'Y'.
I tried two triggers but got the Mutating trigger.....