Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > Oracle Database, SQL, Application, Programming

Sponsored Links

Views: 660 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
Old 05-27-2009, 07:14 AM
bholus7 bholus7 is offline
Join Date:
Apr 2009
Posts: 1,322
Default What is a cursor? What are its types?

What is a cursor? What are its types?

Oracle engine uses private working area to process queries. This work area is called as cursor. The data that is stored in the cursor is called as Active Data Set.

The main types of Cursors are:
Implicit cursors (predefined cursor): - The oracle engine implicitly opens a cursor on the server to process each SQL statement. Implicit cursors are managed by the Oracle engine itself.

Explicit Cursors (user defined cursor): - Explicit Cursors are the cursors created by the user inside a PL/SQL block. The declare section of a PL/SQL block and used within its executable Section.

Reply With Quote

New topics in Oracle Database, SQL, Application, Programming

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.