Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: create trigger
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