写了如下过程: create or replace procedure pro_fir
2 as
3 begin
4 update aa1 t set t.bb=5
5 where t.aa=1111
6 and t.abcdate<=to_char(sysdate-1,'yyyy-mm-dd')
7 and t.abcnum<>5;
8 and;
9 /执行后,提示:Warning: Procedure created with compilation errors
哪里出了错?
2 as
3 begin
4 update aa1 t set t.bb=5
5 where t.aa=1111
6 and t.abcdate<=to_char(sysdate-1,'yyyy-mm-dd')
7 and t.abcnum<>5;
8 and;
9 /执行后,提示:Warning: Procedure created with compilation errors
哪里出了错?
create or replace procedure pro_fir
2 as
3 begin
4 update aa1 t set t.bb=5
5 where t.aa=1111
6 and t.abcdate<=to_char(sysdate-1,'yyyy-mm-dd')
7 and t.abcnum<>5;
8 and; --end;
9 /
多谢高手果然是and的缘故