-
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!
Hemant
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|