Skip to Main Content

What is the difference between "select * bulk collect into... " and "fetch cursor bulk collect into"

User_NYZKSOct 8 2022

In Oracle. What is the difference between?

select * bulk collect into value from table

and

fetch cursor bulk collect into value

I understand that when looping through a cursor and doing bulk fetching, you can limit bulk padding with the "limit" property. In that case, wouldn't it be better then to just use the "select" since it inserts the entire table at once?
In which cases to use each one?
Thank you.

Comments
Post Details
Added on Oct 8 2022
1 comment
56 views