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;