BULK FORALL
来源:互联网 发布:苹果手机怎么设置数据下载 编辑:程序博客网 时间:2024/06/01 21:26
declare
cursor mycursor is SELECT ROWID FROM TEST WHERE XXX=XXXX order by rowid; <--------按ROWID排序的Cursor,删除条件是XXX=XXXX,根据实际情
况来定。
type rowid_table_type is table of rowid index by pls_integer;
v_rowid rowid_table_type;
BEGIN
open mycursor;
loop
fetch mycursor bulk collect into v_rowid limit 5000; <--------每次处理5000行,也就是每5000行一提交
exit when v_rowid.count=0;
forall i in v_rowid.first..v_rowid.last
delete from test where rowid=v_rowid(i);
commit;
end loop;
close mycursor;
END;
/
cursor mycursor is SELECT ROWID FROM TEST WHERE XXX=XXXX order by rowid; <--------按ROWID排序的Cursor,删除条件是XXX=XXXX,根据实际情
况来定。
type rowid_table_type is table of rowid index by pls_integer;
v_rowid rowid_table_type;
BEGIN
open mycursor;
loop
fetch mycursor bulk collect into v_rowid limit 5000; <--------每次处理5000行,也就是每5000行一提交
exit when v_rowid.count=0;
forall i in v_rowid.first..v_rowid.last
delete from test where rowid=v_rowid(i);
commit;
end loop;
close mycursor;
END;
/
0 0
- BULK FORALL
- forall and bulk collect
- BULK COLLECT,FORALL
- bulk collect,forall,fetch..limit
- Oracle Forall 与BULK COLLECT
- bulk collect,forall,fetch..limit
- oracle forall 和 BULK COLLECT
- ORACLE的BULK COLLECT和FORALL
- ,FORALL和bulk collect的使用
- FORALL与BULK COLLECT的使用方法:
- ORACLE 批量绑定 FORALL 与 BULK COLLECT
- oracle10g批量绑定forall bulk collect
- ORACLE批量绑定FORALL与BULK COLLECT
- 【转,改】forall与bulk collect
- FORALL与BULK COLLECT的使用方法
- ORACLE批量绑定FORALL与BULK COLLECT
- oracle forall,bulk collect的使用
- ORACLE批量绑定FORALL与BULK COLLECT
- 查找最小的k 个元素
- Delphi书籍汇总
- 二叉树的一些问题
- shell中内建命令exec、source解析
- Android中的Touch事件处理方式
- BULK FORALL
- 读朱兆祺攻破C语言之八---内存分配与内存释放
- 在pentium4/865芯片组上移植VxWorks5.5的经验
- 大型网站的监控、报警与故障转移
- 大型网站的负载均衡器、db proxy和db
- 被诅咒的程序员的七宗罪
- USB学习笔记3:端点与传输模式
- 大型网站后台架构的web server与缓存
- 吐血整理 Delphi系列书籍 118本(全)