Re: Trigger needed

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 24 Nov 1999 23:16:32 +0100
Message-ID: <943481867.7135.0.pluto.d4ee154e@news.demon.nl>

begin
:new.<column_name> := sysdate;
end;

Hth,

--
Sybrand Bakker, Oracle DBA
<thadc_at_my-deja.com> wrote in message news:81hkae$d8c$1_at_nnrp1.deja.com...
> Hello all,
> I need the pl/sql block for a trigger that will update a column in my
> table with the system date whenever an insert or an update occurs.
>
> thanks in advance
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 24 1999 - 16:16:32 CST