create or replace trigger before_tri before update of status on user for each row
when (old.status=1 and new.status=0)
declare
id number;
begin
select id into aaa from mytest where rownum < 2;
update mytest set id=id+1;
end;
when (old.status=1 and new.status=0)
declare
id number;
begin
select id into aaa from mytest where rownum < 2;
update mytest set id=id+1;
end;
select id into aaa from mytest where rownum < 2;
应改为
create table aaa as
select id from mytest where rownum < 2;
everydream(可口可乐),不明白什么意思????