Cursor variables, PL-SQL Programming

What Are Cursor Variables ?

The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, declaring a cursor variable creates a pointer, not an item. In the PL/SQL, the pointer has a datatype REF X, where REF is short form for the REFERENCE and X stands for the class of objects. Therefore, a cursor variable has the datatype REF CURSOR.

To execute a multi-row query, the Oracle opens an unnamed work region which stores processing the information. To access the information, you can use an explicit cursor that names the work area. Or, you can use a cursor variable that points to the work region. While the cursor always refers to the similar query work region, a cursor variable can refer to various work regions. Therefore, the cursors and cursor variables are not interoperable.

Posted Date: 10/4/2012 3:57:49 AM | Location : United States







Related Discussions:- Cursor variables, Assignment Help, Ask Question on Cursor variables, Get Answer, Expert's Help, Cursor variables Discussions

Write discussion on Cursor variables
Your posts are moderated
Related Questions
Parameter and Keyword Description: dynamic_string: This is a string variable, literal, or expression which represents a SQL statement or the PL/SQL block. define_vari

Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com

Updating by insertion Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

Creating and Destroying Base Tables: Example shows an SQL command to create the base table counterpart of the ENROLMENT variable Example  Creating a base table. CREATE T

TTITLE and BTITLE are commands in Pl-SQL to control report headings and footers. This Ttitle & Btitle are mainly used on creating SQL*PLUS report. Ttitle is used for toptitle headi

Project Description: I want to rebuild it and add better content to it It will include up to 5 forms The data will be saved on SQL server and the data access layer could b

Row Counterparts of Table Operators SQL does not have counterparts tuple rename, tuple projection, tuple extension, tuple join and tuple compose. To obtain the same effects as

Example of Null operator - NiNo Rule If we wanted to make HIGHER_OF adhere to "NULL in, NULL out"-let's call it the NiNo rule-we would have to write something like what is sho

Updating a Variable Assignment of an attribute value in a variable of a structured type Synatx: SET SN.C = 'S2'; As in Example the entire statement is equivalent to a