Re: Newbie Question on trigger...

From: <smenard_at_avior.ca>
Date: Tue, 01 Oct 2002 14:28:35 -0400
Message-ID: <20021001.142833.937370163.14123@avior.ca>

In article <6cljpu8dtoaj645fnd1vtl6dn7bcs4tdbo_at_4ax.com>, "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote:

> On Tue, 01 Oct 2002 10:52:32 -0400, 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!!!

>
>
> You can grant update privilege on individual columns. Simply do not
> grant update privilege and you are set.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

ths a lot... very easy that way .... now i see why you are Senior.... Received on Tue Oct 01 2002 - 13:28:35 CDT