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: create trigger

Re: create trigger

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/31
Message-ID: <965062426.10086.3.pluto.d4ee154e@news.demon.nl>#1/1

correct syntax is
:old.<column name> and :new.<column name> as is well documented.

Hth,

Sybrand Bakker, Oracle DBA

"luio" <lctNOlcSPAM_at_hotmail.com.invalid> wrote in message news:09b7c9ac.4b2c1df3_at_usw-ex0104-028.remarq.com...
> in a trigger,
> how can I reference old table?
>
> it always report that 'old' must be declared
>
> how can I declare it? i have tried
>
> referencing old as old
>
> or referenceing old as 'oldname'.
>
> then use old or oldname, but none of them will work.
>
>
>
> if do not do any reference, use old directly, it will not work
> too?
>
> then in this case, how can use old table in my trigger?
>
>
>
>
>
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Mon Jul 31 2000 - 00:00:00 CDT

Original text of this message

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