Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> tell updated fields from within preupdate trigger

tell updated fields from within preupdate trigger

From: <dov_shnaider_at_my-dejanews.com>
Date: Fri, 22 May 1998 18:43:16 GMT
Message-ID: <6k4h04$8aq$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US