标题: 关于oracle中continue的用法请教 [打印本页] 作者: saner3 时间: 2003-10-21 13:49 标题: 关于oracle中continue的用法请教 程序体大致如下:
declare
cursor a is v_sql;
begin
open a;
loop;
begin
fetch a into v_a;
exit when a%notfound;
exception when others then
colse a;
open a;
goto continue;
end;
update table1 set a=:b where condition;
commit;
<<continue>;>;
此处该怎么写?
end loop;
end;
/