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.