个人改进建议:
1、游标取数时,采用批量取数的方法:
fetch cur bulk collect into (nested table/varray/index table) limit 1000;
2、UPDATE、INSERT语句采用动态SQL:
execute immediate 'update table set col1 = :x,col2 = :y, ...' using v1,v2,...;
个人改进建议:
1、游标取数时,采用批量取数的方法:
fetch cur bulk collect into (nested table/varray/index table) limit 1000;
2、UPDATE、INSERT语句采用动态SQL:
execute immediate 'update table set col1 = :x,col2 = :y, ...' using v1,v2,...;