BULK COLLECT in Oracle

Bulk collect is used to load a bulk of data from a table.BULK COLLECT is usually using alsong with INTO clause.We want to load whole data of a particular column according to a condition we can use BULK COLLECT . We have to declare array or a table type or a row type of variable to store datas .

DECLARE

   type akhil_tp is table of   employee.ename%type;
  lv_akhil_tp   akhil_tp;
 begin
 
  select ename BULK COLLECT INTO lv_akhil_tp from employee;
for i in 1..lv_akhil_tp.count() loop
dbms_output.put_line(lv_akhil_tp(i));
end loop;
end;