Trigger question

[air~traffic]

Hi all
I have a question and maybe you'll be able to help me.

I have a table (Oracle 8.1.7) with trigger on it (instead of update). Is there a way to identify columns of this table listed in SET clause of UPDATE statement, which fired trigger, in trigger's code ?

Thanks in advance for answers

[LKBrwn_DBA]

Only by comparing ':NEW' to ':OLD'. :)

[slimdave]

I have a table (Oracle 8.1.7) with trigger on it (instead of update).

What you have there is either a view with an instead-of-update trigger, or a table with an on-update trigger -- you can't place an instead-of trigger on a table.