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

On Oct 21, 7:57 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> Krista <ywa..._at_gmail.com> wrote in news:1193017317.584469.269100
> @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
>
> SQL> SHOW ERROR- Hide quoted text -
>
> - Show quoted text -

after i typed show error, it shows

LINE/COL ERROR

-------- -----------------------------------------------------
3/5      PL/SQL: SQL Statement ignored
3/62     PL/SQL: ORA-00920: invalid relational operator

i am just beginner, so i am not quit sure what it mean....3/5 mean line 3? but how about 5? what is the meaning column 5 ?anyone can help?

krista Received on Sun Oct 21 2007 - 22:11:31 CDT