Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How Many Type's of Cursors are Available In PL/SQL?

user-image
Question ajoutée par Utilisateur supprimé
Date de publication: 2016/05/03
KULDEEP KATARIA
par 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
par Gokul Ganesh , Senior Product Specialist , Cognizant - India

two types

1. Implicit 

2. explicit

Shessy Chalackal Shaju
par 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.

Utilisateur supprimé
par Utilisateur supprimé

1- Static Cursors

2- Dynamic Cursors

3- Forward Only Cursors

4- Keyset Driven Cursors

More Questions Like This