create or replace trigger ChangeDisplay after insert on evaluate
begin
select * from evaluate;
end;
如上在创建触发器的时候,提示PLS-00428:在此select语句中缺少INTO子句。请问该怎么改?oracle触发器
begin
select * from evaluate;
end;
如上在创建触发器的时候,提示PLS-00428:在此select语句中缺少INTO子句。请问该怎么改?oracle触发器
after insert --在插入之后
on city
for each row
begin
insert into city_temp(city)values(:new.city); --insert操作只有:new;delete操作只有:old;update操作两者都有
end;
v_id varchar2(20);
begin
select id into v_id from evaluate;
end;
before delete on emp2
begin
insert into emp2_bak select * from emp2 ;
end ;