-
Bulk Collect loop and Cursor Loop
Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks
Last updated: -
BULK COLLECT and FORALL in PL/SQL
How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.
Last updated: -
Bulk Collect vs Cursor in Oracle
Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...
Last updated: -
COmplex update takes a 90 minutes to run in Oracle
In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table hasĀ 40 records. It has been written by someone else, I don't have access to Oracle so can't check my thinking, but I believe, if we select the data to be updated into pl/sql tables,...
Last updated: