Newbie Question on trigger...

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!!! Received on Tue Oct 01 2002 - 09:52:32 CDT