Start networking and exchanging professional insights

Register now or log in to join your professional community.

KULDEEP KATARIA
by KULDEEP KATARIA , Team Member

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.

Gokul Ganesh
by Gokul Ganesh , Senior Product Specialist , Cognizant - India

two types

1. Implicit 

2. explicit

Shessy Chalackal Shaju
by Shessy Chalackal Shaju , Operation Coordinator , Barq Construction and Trading

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

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.