Cursor and bulk collect Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cursor and bulk collect

  1. #1
    Join Date
    May 2004

    Cursor and bulk collect

    Have a basic doubt in PLSQL. Why use a cursor fetch to bulk collect data into a collection - I had the idea that cursor gave control over the result-set. When i am bulk collecting data then what is the use of a cursor.

    Moreover, if i have a complex query involving 2 or more tables with joins - can i do a bulk collect into a collection - all the examples were simple queries. i think we can. plzz correct me if i am wrong.


  2. #2
    Join Date
    Nov 2002
    Geneva Switzerland
    You use one or the other.

    Some discussion here on performace of the two methods:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width