TYPES OF CURSORS IN PL/SQL

Posted Date: 11 May 2008 Resource Type: Articles/Knowledge Sharing Category: Computer & Technology

Posted By: Nikky Member Level: Gold
Rating:

Points: 2

IMPLICIT CURSORS

Whenever user executes SQL statement Oracle engine automatically opens a cursor on the server to process each SQL statement and to store the results of these statements in memory area. This memory area is marked as cursor.

Management and feeding of data in that area is done by Oracle engine itself. They are opened and managed by Oracle engine internally. So there is no need to open and manage by the users, these operations are performed automatically. For this reason they are called as IMPLICIT CURSORS.

EXPLICIT CURSORS

EXPLICIT CURSORS are user-defined cursors for processing of multiple records returned by a query. The developer declares explicit cursors.

This type of cursor is manually declared by the developer in the declare section of PL/SQL block followed by a SELECT statement and manually opened, used and released in executable section of PL/SQL block.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: CURSORS
	Previous Resource: Display a message to check whether the record is deleted or not with the use of SQL%NOTFOUND
	Return to Discussion Resource Index
	Post New Resource
	Category: Computer & Technology

Post resources and earn money!

Related Resources

Fresher Jobs

Resources

Colleges

TYPES OF CURSORS IN PL/SQL

Responses

Post Feedback