Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to determine if a column has been updated inside a trigger
Is it possible to determine if a column has been updated inside a trigger [message #224658] Thu, 15 March 2007 00:34 Go to next message
ericonice
Messages: 2
Registered: September 2006
Junior Member
Inside a trigger, I would like to know if a column has been updated (but not necessarily modified). For example, for:

update dept set dept_loc=dept_loc

I would like to know that dept_loc has been updated (but not modified). I believe sql server supports this via an UPDATE() function.

Is there anything similar in Oracle?
Re: Is it possible to determine if a column has been updated inside a trigger [message #224787 is a reply to message #224658] Thu, 15 March 2007 08:23 Go to previous message
aorehek
Messages: 52
Registered: August 2006
Member
Try this in trigger code :

IF UPDATING('YOUR_FIELD_NAME') THEN ....

Previous Topic: colection error
Next Topic: Foreign key
Goto Forum:
  


Current Time: Mon Dec 05 04:41:27 CST 2016

Total time taken to generate the page: 0.04816 seconds