Closing a Cursor

The CLOSE statements disable the cursor, and the result set becomes undefined. An illustration of the CLOSE statement as shown:

CLOSE c1;

Posted Date: 10/4/2012 3:54:51 AM | Location : United States

Ask an Expert

Related Discussions:- Closing a cursor - explicit cursor, Assignment Help, Ask Question on Closing a cursor - explicit cursor, Get Answer, Expert's Help, Closing a cursor - explicit cursor Discussions

Write discussion on Closing a cursor - explicit cursor
Your posts are moderated

Write your message here..

Related Questions

Type versus representation confusion in sql, Type versus Representation Con... Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla

Example of table literal - sql, Example of Table Literal - SQL Exampl... Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'

Sql queries, SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.par... SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

Use serially reusable packages - performance of application, Use Serially R... Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

Program, heap sort program in pl/sql heap sort program in pl/sql

Declaring and initializing objects in pl/sql, Declaring and Initializing Ob... Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Using operator deref - manipulating objects in pl sql, Using Operator DEREF... Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

Declare keyword description in pl sql, DECLARE : This keyword signals t... DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the

Remote operations in pl sql, Remote Operations: As the illustration sh... Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Data types in sql - decimal, Data Types in SQL - Decimal DECIMAL, NUME... Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ