InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Use Of Cursors In Pl/sql? What Is Ref Cursor? |
|
Answer» The cursor is used to handle MULTIPLE row query in PL/SQL. ORACLE uses implicit cursors to handle all its queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor VARIABLE which will point to that memory SPACE and can be used like POINTERS in our 3GLs. The cursor is used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all its queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs. |
|