How To Avoid Using Cursors? What To Use Instead Of Cursor And In What

1.	How To Avoid Using Cursors? What To Use Instead Of Cursor And In What Cases To Do So?
Answer» Just use subquery in for clause ex: For emprec in (SELECT * from emp) loop dbms_output.put_line(emprec.empno); end loop; no EXIT STATEMENT needed implicit OPEN,fetch,CLOSE occurs. Just use subquery in for clause ex: no exit statement needed implicit open,fetch,close occurs.

How To Avoid Using Cursors? What To Use Instead Of Cursor And In What Cases To Do So?

Answer»

Just use subquery in for clause

ex:

For emprec in (SELECT * from emp) loop dbms_output.put_line(emprec.empno); end loop;

no EXIT STATEMENT needed implicit OPEN,fetch,CLOSE occurs.

Just use subquery in for clause

ex:

no exit statement needed implicit open,fetch,close occurs.