About %ROWTYPE in PL/SQL.

content:

 declare
 v_emp emp%rowtype;
 cursor c_emp is select * from emp;
 begin
 open c_emp;
 loop
 fetch c_emp into v_emp;
 exit when c_emp%NOTFOUND;
 dbms_output.put_line('Salary of Employee '||v_emp.ename||' is '||v_emp.sal);
 end loop;
 close c_emp;
 end;