Hi,
I am using oracle 11g version.
How can I access the data in the table variable V_emp?
set serveroutput on size unlimited
declare
type emp_type is table of emp%rowtype
index by binary_integer;
v_emp emp_type;
begin
select emp.* bulk collect into v_emp
from emp;
for i in 1..v_emp.count
loop
dbms_output.put_line(How can I display all the data in the table variable v_emp??);
end loop;
end;
/
Thanks