Search your topic here

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.

LEAVE A REPLY










Related topics

Please use contact page in this website if you find anything incorrect or you want to share more information about the topic discussed above.