Live ORACLE

DECLARE

TYPE empcurtyp IS REF CURSOR RETURN employees%ROWTYPE;

 emp_cv   EMPCURTYP;

 emp_rec  employees%ROWTYPE;

BEGIN

OPEN emp_cv FOR

  SELECT *

  FROM   employees

  WHERE  employee_id < 120;



LOOP

  FETCH emp_cv INTO emp_rec; -- fetch from cursor variable



  EXIT WHEN emp_cv%NOTFOUND; -- exit when last row is fetched



  -- process data record

  dbms_output.Put_line('Name = '

                       ||emp_rec.first_name

                       ||' '

                       ||emp_rec.last_name);

END LOOP;



CLOSE emp_cv;

END;

/

Name = Steven King
Name = Neena Kochhar
Name = Lex De Haan
Name = Alexander Hunold
Name = Bruce Ernst
Name = David Austin
Name = Valli Pataballa
Name = Diana Lorentz
Name = Nancy Greenberg
Name = Daniel Faviet
Name = John Chen
Name = Ismael Sciarra
Name = Jose Manuel Urman
Name = Luis Popp
Name = Den Raphaely
Name = Alexander Khoo
Name = Shelli Baida
Name = Sigal Tobias
Name = Guy Himuro
Name = Karen Colmenares

PL/SQL procedure successfully completed.

Fetching from a Cursor Variable into a Record