Cursor and bulk collect

[prasen999]

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

[DaPi]

You use one or the other.

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