Home » SQL & PL/SQL » SQL & PL/SQL » Create Update trigger
Create Update trigger [message #241049] Mon, 28 May 2007 04:32 Go to next message
Messages: 2
Registered: May 2007
Location: Bangalore
Junior Member

Dear Sir/Mam,
I am writing a trigger for update. I need to store the table name, column name its old value and new value in a different table. Is there a way to compare only the columns being modified or Do I have to check old and new values of all the columns and then do insert into another AUDIT table individually.

Your help at the earliest is appreciated.

Re: Create Update trigger [message #241052 is a reply to message #241049] Mon, 28 May 2007 04:35 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Previous Topic: Duplicate Rows
Next Topic: CASE Expression
Goto Forum:

Current Time: Fri Aug 18 00:13:52 CDT 2017

Total time taken to generate the page: 0.14890 seconds