This example shows how to use Comosite Rowtype in pl/sql
declare e_name emp%rowtype; cursor emp_cur is select * from emp; begin for i in emp_cur loop dbms_output.put_line(i.ename||','||i.job); end loop; end;