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 ...
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.