Register now or log in to join your professional community.
In Oracle, there are two types of cursor available:-
1) Implicit
2) Explicit
Implicit cursor automatically gets created when a select statement is executed.
Explicit cursor are programmer defined for gaining more control/Maniulation over the rows returned by the Select Query.
two types
1. Implicit
2. explicit
There are two types of cursor available
1) Implicit
2) Explicit
Implicit cursor automatically gets created when a statement is executed without the explicit cursor.
E.g. While inserting a row the cursor contains the data to be inserted
Explicit cursor are programmer defined for gaining more control over the context area.
1- Static Cursors
2- Dynamic Cursors
3- Forward Only Cursors
4- Keyset Driven Cursors
