Live ORACLE

DECLARE

 CURSOR c1 IS

   SELECT last_name,

          salary,

          hire_date,

          job_id

   FROM   employees

   WHERE  employee_id = 120;

  -- declare record variable that represents a row fetched from the employees table

  employee_rec  c1%ROWTYPE;

BEGIN

 -- open the explicit cursor and use it to fetch data into employee_rec

 OPEN c1;



 FETCH c1 INTO employee_rec;



 dbms_output.Put_line('Employee name: '

                      ||employee_rec.last_name);

END;

/

Using %ROWTYPE with an Explicit Cursor