SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know only updated columns in a trigger?

414300Mar 17 2004 — edited Mar 18 2004

Hi,
In a trigger i want to know all the updated columns. I can compare :new.value and :old.value but my table has got around 60 coulmns.

Is there any way to find what the columns updated(only updated) when user executes a UPDATE Query.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2004

Added on Mar 17 2004

6 comments

738 views