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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Question on trigger...

Re: Newbie Question on trigger...

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 01 Oct 2002 15:31:33 GMT
Message-ID: <3D99BFC0.827E24D6@exesolutions.com>


smenard_at_avior.ca wrote:

> It's there way in a trigger to compare all element in :new and :old with
> a loop or things like that :
>
> for i in :new
> loop
> if :new[1]!=:old[1] then
> raise_application_error('-20002','not good');
> end if;
> end loop;
>
> or i must compare one by one like that ...
> :new.nbr=:old.nbr
> :new.crap=:old.crap
>
> I need that in one of my table ... this table must be update in just one
> column (status) and my trigger must check that no others colums are update
> how i implement that short and sweet....
>
> Thanks you!!!

It must be done on a column by column basis but there is a work-around of sorts.

Concatenate the other fields together into a single string and compare the two strings.

Daniel Morgan Received on Tue Oct 01 2002 - 10:31:33 CDT

Original text of this message

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