Answers

Question and Answer:

  Home  Oracle PL-SQL

⟩ How to avoid using cursors? What to use instead of cursor and in what cases to do so?

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

 198 views

More Questions for you: