sql - Optimization of for loop in oracle -

i asked on apprenticeship following question: why query like:

for in ( select * tabelka) loop 

is not efficient? how change make more efficient?

there no further information added.

collect, data @ once, collection. boom! 1 query , have without looping.

select * bulk collect a_collection_type_variable a_table;