CURSOR

DECLARE
CURSOR emp_show IS
    SELECT employee_id,first_name,salary
    FROM employees;

    emp_rec emp_show%ROWTYPE;


BEGIN

OPEN emp_show;

FETCH emp_show INTO emp_rec;

WHILE emp_show%found
LOOP


DBMS_OUTPUT.put_line('employee id: '||emp_rec.employee_id);
DBMS_OUTPUT.put_line('First Name : '||emp_rec.first_name);
DBMS_OUTPUT.put_line('Salary : '||emp_rec.salary);
FETCH emp_show INTO emp_rec;
END LOOP;

CLOSE emp_show;

END;