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

Thread: Cursor and bulk collect

  1. #1
    Join Date
    May 2004
    Posts
    29

    Cursor and bulk collect

    Folks,
    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.

    regards,
    Prasenjit

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    You use one or the other.

    Some discussion here on performace of the two methods:
    http://asktom.oracle.com/pls/ask/f?p...:3561337894959

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