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, and [...]

Answer Question   |  February 1, 2011  4:19 PM
BULK COLLECT statement, Oracle, Oracle administration, Oracle Processes, Oracle Query

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.

Answer Question   |  April 19, 2013  3:11 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL

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

Answer Question   |  January 12, 2009  9:58 AM
BULK COLLECT statement, Cursor, Cursor Loop, loop, Oracle

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 [...]

Answer Question   |  April 18, 2013  3:38 PM
BULK COLLECT statement, Collection Loop, Cursor Loop, LOOP statement, Oracle Cursors, Oracle development, Oracle queries