> Is it possible for a trigger to manipulate the column values of the table to
> which it is attached?

Not directly.  You can do this in an AFTER UPDATE or AFTER INSERT trigger if
the table has a primary key.  You get the key value from the SYS_NEW cursor,
and then issue an UPDATE statement against the table.  I assume (but don't know
for sure) that this would also fire the UDPATE trigger, so you have to be
careful not to get caught in an infinite loop (the trigger must only issue the
UDPATE under certain conditions, and the UDPATE you issue should not fulfill
those conditions).
--
Larry

Reply via email to