Each updated column name in trigger
Hi,
I know by applying new.value <> old.value ,
we can know which column got update bt i hv number of columns in my table so it is not possible to write new.value <> old.value for all columns with IF-ELSE statements.
I need to create log table for my master table , so log table contains only field name(i.e. column name) and old and new value.
Is that possible except new.value <> old.value clause ?
Please reply
Thanks.
Subject
Views
Written By
Posted
Each updated column name in trigger
3306
December 27, 2010 08:46AM
1466
December 27, 2010 02:10PM
4398
January 06, 2011 02:08AM
1668
January 06, 2011 01:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.