Hi Gurus,

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.....

Help Guys!