Diksha IT Training Centre

Cursor and Types of Cursor in Oracle with Examples.   Hello Everyone, Today I will discuss about Cursor in Oracle and it’s uses in PL/SQL anonymous block. Cursor is very important part in PL/SQL .Cursor act as a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is referred to as the active set. For example: The number of rows processed through multiple table and that cursor can be used in that block. For our convenient we name a cursor so that it could be referred to in a program to fetch and process the rows returned by the SQL statement, one at a time. There are three types of cursors   in Oracle ·         Implicit cursors : Maintained By Oracle Server Itself ·          Explicit cursors : Controlled by programmer so in Explicit Cursor Programmer need to follow the below step to use a cursor in PL/SQL Block.             Declare the Cursor