Re: How to create trigger after update on the simple slide

"Krista" <ywanip_at_gmail.com> schreef in bericht news:1193017317.584469.269100_at_e34g2000pro.googlegroups.com...
> Hi everyone,
>
> I am practice on create trigger in Oracle. I found some simples online
> and tried to put it in my computer. However, it pops up an error
> messge "warning: trigger created with compilation errors."
>
> Question: we want the net worth of any executive to be below $50000.
>
> First i created the table:
> create table movieexce(name varchar2(50) primary key, address
> varchar2(50), networth number(9,2));
>
> Second i tried to create trigger: ( actually, i put the same thing on
> the net to test it)
> create or replace trigger avgnetworthafterupdate
> after update of networth on movieexce
> referencing
> old as oldstuff
> new as newstuff
> begin
> if (50000>(select avg(networth) from movieexce)) then
> delete from movieexce where (name, address, networth) in newstuff;
> insert into movieexce (select * from oldstuff);
> end if;
> end avgnetworthafterupdate;
> /
> Result:warning: trigger created with compilation errors.
>
> any one has clue what is wrong with that trigger?
>
> Thanks,
> Krista
>

How about:

if newstuff.networth > 50000 then newstuff.networth := oldstuff.networth; end if;

or

if newstuff.networth > 50000 then newstuff.networth := 50000; end if;

I think this meets your specs (though no messages or whatever to the performer of the update....)

Shakespeare Received on Mon Oct 22 2007 - 07:03:14 CDT