EXPLICIT CURSOR EG

DECLARE

          CURSOR c1 is SELECT * FROM emp;

          str_empno emp.empno%type;

          str_ename emp.ename%type;

          str_job emp.job%type;

          str_mgr emp.mgr%type;

          str_hiredate emp.hiredate%type;

          str_sal emp.sal%type

          str_comm emp.comm%type;

          str_deptno emp.deptno%type;

          rno number;

BEGIN

          rno := &rno;

          FOR e_rec IN c1

          LOOP

                    IF c1%rowcount = rno THEN

 DBMS_OUTPUT.PUT_LINE (str_empno || ' ' || str_ename || ' ' 

|| str_job || ' ' || str_mgr || ' ' || str_hiredate || ' ' || str_sal || ' ' 

|| str_comm || ' ' || str_deptno);

                    END IF;

END LOOP;
END;