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

Home -> Community -> Usenet -> c.d.o.tools -> Re: table trigger questions

Re: table trigger questions

From: Yogesh Sharma <sharmayNOSPAM_at_usa.net.NOSPAM>
Date: 2000/05/12
Message-ID: <391C68BA.62E5A719@usa.net.NOSPAM>#1/1

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

Original text of this message

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