|
What is a cursor? What are its types? |
Views: 1574
|
Thread Tools | Rate Thread |
#1
|
|||
|
|||
What is a cursor? What are its types?
What is a cursor? What are its types?
Answer Oracle engine uses private working area to process queries. This work area is called as cursor. The data that is stored in the cursor is called as Active Data Set. The main types of Cursors are: Implicit cursors (predefined cursor): - The oracle engine implicitly opens a cursor on the server to process each SQL statement. Implicit cursors are managed by the Oracle engine itself. Explicit Cursors (user defined cursor): - Explicit Cursors are the cursors created by the user inside a PL/SQL block. The declare section of a PL/SQL block and used within its executable Section. |