Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> tell updated fields from within preupdate trigger
Hi,
Is there a way to tell what fields an update statement is trying to update
from within a server-side pre-update trigger ?
e.g.
the user issues : update table set field1=vl1 field2=val2 field3=val3
when val1,val2,val2 may or may not be identical to the current values in the
table row.
can the pre-update trigger identify the particular field names: field1,field2,field3 (even when the new and old values are identical) ?
Thanks
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 13:43:16 CDT
![]() |
![]() |