Types of cursors

TYPES OF CURSOR IN ORACLE DATABASE:


IMPLICIT CURSOR:
1) These are the cursors which are automatically gets created by Oracle server when DML SQL statement gets executed.
2) Users can not control the behavior of these cursors.
3) Oracle server creates an implicit cursor in background for any PL/SQL block which executes an SQL statement. As long as an explicit cursor does not exist for that SQL statement.

EXPLICIT CURSOR:
1) Explicit cursors are user defined cursors which means user has to create this cursor for any statement which returns more than one row of the data.
2) Unlike implicit cursor user has full control over explicit cursor.

READ ALSO:
What is CURSOR? Click here.
How to create Explicit Cursor click here.

More topics from DBMS to read:

DATABASE MANAGEMENT SYSTEM

EasyExamNotes.com covered following topics in DBMS.
A list of Video lectures

Post a Comment

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.