OraFAQ Forum: SQL & PL/SQL » Is it possible to determine if a column has been updated inside a trigger

Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to determine if a column has been updated inside a trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is it possible to determine if a column has been updated inside a trigger [message #224658]

Thu, 15 March 2007 00:34

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?

Report message to a moderator

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

aorehek
Messages: 52
Registered: August 2006

Member

Try this in trigger code :

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

Report message to a moderator

Previous Topic:	colection error
Next Topic:	Foreign key

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 06:35:32 CST 2024