Closing a cursor - explicit cursor, PL-SQL Programming

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







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
Related Questions
Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

1- You can check attribute names from each table in DBF11 by running for example:  desc dbf11.Member;  desc dbf11.Agent;  desc dbf11.Producer; Because some attribute names in

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

What Are Subprograms? The Subprograms are named PL/SQL blocks which can take parameters and be invoked. The PL/SQL has 2 types of subprograms known as the procedure s and func

BIOCHE M ICA L ORIGIN OF LIFE - It is generally agreed by astronomers, geologists and biologists that the earth is approximately 4500-5000 million years old. It is an

write the program for traffic control system with 10 second, 15 secod, and 20 second delay

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Data Types in SQL - XML, Array, Row BINARY LARGE OBJECT for arbitrarily large bit strings. XML for XML documents and fragments. ARRAY types for arrays.