The Cursor is a handle (name or a pointer) for the memory associated with a specific statement. A cursor is basically an Area alocated by Oracle for executing the Sql Statements. Oracle Uses an Implicit Cursor statement for a single row query and Explicit Cursor for a multi row query.
Types of Cursor :
I) Implicit
2) Expicit
Flow in Explicit Cursor
------------------------------
I. Declaring a cursor :- Involves assign a name to cursor and associating a query with it..
II. Open the cursor :- Executes the query and identify the result set.
III. Fetch the cursor :- gets the result set and Loops through to process them
IV. Close the cursor :- Releases the cursor
Types of Cursor :
I) Implicit
2) Expicit
Flow in Explicit Cursor
------------------------------
I. Declaring a cursor :- Involves assign a name to cursor and associating a query with it..
II. Open the cursor :- Executes the query and identify the result set.
III. Fetch the cursor :- gets the result set and Loops through to process them
IV. Close the cursor :- Releases the cursor
No comments:
Post a Comment
Please Provide your feedback here