SQL> create table a (id varchar2(10),name varchar2(30));Table createdSQL> create trigger a_tri 2 before update of name on a 3 for each row 4 declare 5 v_name varchar2(100); 6 begin 7 select name into v_name from a; 8 end; 9 /Trigger created没问题,楼主发生什么事性?
new.key 应该是 :new.key 把,楼主太粗心了吧
to: beckhambobo(beckham),语法问题出在commit上,你没用commit当然没错。而“select name into v_name from a;”我想运行的时候就会出现错误了,不信可以试试看。后来没办法,只好通过临时表解决。最后还是谢谢各位的热心。
2 before update of name on a
3 for each row
4 declare
5 v_name varchar2(100);
6 begin
7 select name into v_name from a;
8 end;
9 /Trigger created没问题,楼主发生什么事性?