2021年10月14日 星期四

Oracle BULK COLLECT

 Oracle BULK COLLECT

Oracle数据库之FORALL与BULK COLLECT语句

https://segmentfault.com/a/1190000019344658


PRAGMA EXCEPTION_INIT的用法

https://db-hub.net/2020/11/18/pragma-exception_init%E7%9A%84%E7%94%A8%E6%B3%95/


PL/SQL Optimization and Tuning

https://docs.oracle.com/database/121/LNPLS/tuning.htm#LNPLS012


Collection Method: DELETE Procedure In Oracle Database

http://www.rebellionrider.com/collection-method-delete-procedure-in-oracle-database/


Oracle PL/SQL 的 Array 陣列

https://tomkuo139.blogspot.com/2015/04/oracle-plsql-array.html


Oracle PL/SQL 的 for loop 迴圈使用

https://tomkuo139.blogspot.com/2010/05/oracle-plsql-for-loop.html


PL/SQL跳出迴圈語句(EXIT,CONTINUE,GOTO,EXIT WEHN)操作例項

https://codertw.com/%E7%A8%8B%E5%BC%8F%E8%AA%9E%E8%A8%80/434151/

Parallelizing INSERT, MERGE, UPDATE, and DELETE

https://docs.oracle.com/database/121/VLDBG/GUID-2627DC19-7EBE-4C45-A758-711BDB5E37EC.htm


oracle 并行之二: parallel dml

https://blog.csdn.net/ctypyb2002/article/details/102748239


PL/SQL Table 集合陣列實作 (Oracle Array-like Programming with PL/SQL Table)

https://www.abu.tw/2010/04/plsql-table-oracle-array-like.html