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

On Oct 21, 7:57 pm, "Ana C. Dent" <anaced...@xxxxxxxxxxx> wrote:
Krista <ywa...@xxxxxxxxx> 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

.

Relevant Pages