Re: table trigger questions

Hi

triggers are written on table on insert, update or delete actions. Insert and update :new.<field_name> (where fieldname is the tbale field name) contains new value to be inserted in table. In delete and update :old.<field_name> contains old value that is deleted fromt the table.

Yogesh

Judy Sprague wrote:

> Greetings:
>
> I have a table trigger and the text looks like this:
>
> :new.tablename_activity_date := sysdate
>
> What does new refer to. It is not the table owner.
>
> Thanks,
>
> Susan Goldberg
> susang_at_oregon.uoregon.edu
Received on Fri May 12 2000 - 00:00:00 CDT