想用游标实现删除一个标中的一些记录,这样做为什么出错 for update ?for update of columnname 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 loop; exit when c1%notfonud; delete from tmp where current of c1; commit; end loop; declare cursor c1 is select * from tmp;begin open c1; loop; exit when c1%notfound; delete from tmp where current of c1; commit; end loop; close c1;end; oracle 导入dat数据文件 跪求一个sql语句的写法,100分奉上 求一个SQL语句任意时间消费的条件? 如何读取某一天二十四小时的数据 求一条SQL语句, 初级问题 如何看oracel上的一个存储过程执行了多长时间了(或进度情况)? 求oracle 7.3.4 for sco openserver 5.0.x补丁 请教如何显示oracle9i中自定义包的源代码 导入时字符集问题,求救 表空间'TEST'中无权限? 输出问题
exit when c1%notfonud;
delete from tmp where current of c1;
commit;
end loop;
cursor c1 is select * from tmp;
begin
open c1;
loop;
exit when c1%notfound;
delete from tmp where current of c1;
commit;
end loop;
close c1;
end;