Re: OLD NEW value in trigger ?

eugene kim wrote:

> i couldn't find documentation about this
> it's just my guess..
> please correct me if i'm wrong..
>
> before insert trigger
> :new -> row which contains data being inserted
> :old -> null
>
> before update trigger
> :new -> row which contains data being updated
> :old -> row which already existed before update
>
> before delete trigger
> :new -> null
> :old -> row which will be deleted
>
> after insert trigger
> :new -> row which has been inserted
> :old -> null
>
> after update trigger
> :new -> row which was used to update
> :old -> row which was in db before update
>
> after delete trigger
> :new -> null
> :old -> row which was deleted
>

Correct. but it can be stated more simply:

INSERT ... everything is new
DELETE  ... everything is old
UPDATE ... old is original record ... new is the updated version of the

Daniel Morgan Received on Tue Sep 17 2002 - 11:08:21 CDT