Cursor

DECLARE
emp_row emp%ROWTYPE;
CURSOR emp_cur IS
SELECT *
FROM emp;
BEGIN
OPEN emp_cur;
LOOP

FETCH emp_cur INTO emp_row;
EXIT WHEN emp_cur%NOTFOUND;
DBMS_OUTPUT.PUT_LINE ( 'No. : ' || emp_cur%ROWCOUNT);
DBMS_OUTPUT.PUT_LINE ( 'Employee Number : ' || emp_row.empno);
DBMS_OUTPUT.PUT_LINE ( 'Employee Name : ' || emp_row.ename);
DBMS_OUTPUT.PUT_LINE ( 'Department No. : ' || emp_row.deptno);
DBMS_OUTPUT.PUT_LINE ( 'Manager No. : ' || emp_row.mgr);
END LOOP;
CLOSE emp_cur;
END;
/