<<Previous Next>>
Oracle - What is a cursor?
What are its types? - Feb 07, 2010 at 14:20 PM by Shuchi
Gauri
What is a cursor? What are its
types?
Cursor is used to access the access the result
set present in the memory. This result set contains the records
returned on execution of a query.
They are of 2 types:
1. Explicit
2.
Implicit
Oracle - What
is a cursor? What are its types? - April 10, 2009
at 11:00 AM
What is a cursor? What are its
types?
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.
Also read
What a SELECT FOR UPDATE cursor represent?, What WHERE CURRENT OF
clause does in a cursor?, Can you pass a parameter to a cursor?,
Explain the functioning of CURSOR FOR LOOP with example., Define
Simple/Explicit , Parametric and Internal/Implicit
cursor.............
Normal cursors fall under the category of static cursors while
REF cursors are dynamic.........
A cursor variable works like pointer in C. It is used to hold
address of an item rather than the item itself. Cursor variables can
be used to hold different values at run time............
A
parameter makes the cursor more reusable, A parameter avoids scoping problems...............
|
