Re: Pre update trigger query ..

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 8 Sep 2001 00:17:29 +0200
Message-ID: <tpikt5hden9d2b@news.demon.nl>

"Manoj Nair" <debo_nair_at_yahoo.com> wrote in message news:92a0e580.0109071414.19afdf2a_at_posting.google.com...
> How do i handle this situation?
>
> I have 2 tables...First table has 3 columns......I can update column 2
> and column 3. When I change values in column 3 ( by UPDATE ) and if
> this new value is different from old value in column 3 then I need to
> insert a record in second table...how should i go about this?
>
> Thanks

if updating('column3') and :new.column3 <> :old.column3 then

insert
end if;

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 07 2001 - 17:17:29 CDT