Home » SQL & PL/SQL » SQL & PL/SQL » Getting Column Names Updated When An Update Statement Fires
Getting Column Names Updated When An Update Statement Fires [message #232993] Tue, 24 April 2007 06:39 Go to next message
Messages: 64
Registered: August 2006
Location: Bangalore, India
Dear All,

I'm working on oracle 9i under unix env. I've a table accessing by 10 users through a frontend.This table has 225 columns.
This table has a after update trigger on it. When any of the user updating a column value triggers fires and try to generate the same update and store it into a table.

Now my problem is how can i know which column is getting updated by the update statement run by the user. If i'll compare all the columns using new and old it will become a lengthy code, even if i use new and old then to store the same sql statement i've to put single quotes in update statement for the columns having datatype varchar2, char or date.

Is thr any method so that i can came to know that these specific columns are getting updated.

Either Can you tell me how log-miner is generating sql_undo statment for the DML's.

Re: Getting Column Names Updated When An Update Statement Fires [message #233001 is a reply to message #232993] Tue, 24 April 2007 06:48 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You have to check old and new value column per column
2/ LogMiner generates undo sql from redo record that contains a binary form of redo sql.

Previous Topic: insert or update
Next Topic: Number of triggers in a table.
Goto Forum:

Current Time: Mon Aug 21 09:11:36 CDT 2017

Total time taken to generate the page: 0.09826 seconds