1 - 3 of 3
PREVIOUS 1 NEXT
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.
How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.
20 pts.
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
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
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...
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...
1 - 3 of 3
PREVIOUS 1 NEXT
