Chinaunix

标题: 关于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;
/




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2