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

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

What is a cursor? What are its types?

Answer
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.

Ads
Reply With Quote
Reply

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 - 2018, vBulletin Solutions, Inc.
asp web stats