Close statement in pl sql, PL-SQL Programming

CLOSE Statement

The CLOSE statement allows the resources held by a cursor variable or open cursor to be reused. No more rows can be fetched from the cursor variable or closed cursor.

Syntax:

684_pl sql.png

Keyword and Parameter Description

cursor_name:

These identify an explicit cursor previously declared within the present scope and presently open.

 cursor_variable_name:

These identify the PL/SQL cursor variable previously declared within the present scope and presently open.

host_cursor_variable_name:

These identify a cursor variable declared in the PL/SQL host atmosphere and passed to the PL/SQL as a bind variable. The host cursor variable datatype is well-suited with the return type of any PL/SQL cursor variable. The host variables should be prefixed with a colon.

Posted Date: 10/6/2012 8:58:40 AM | Location : United States







Related Discussions:- Close statement in pl sql, Assignment Help, Ask Question on Close statement in pl sql, Get Answer, Expert's Help, Close statement in pl sql Discussions

Write discussion on Close statement in pl sql
Your posts are moderated
Related Questions
Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

On occasion, some of Brewbean's customers mistakenly leave an item out of a basket already checked out, so they create a new basket containing the missing items. However, they requ

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

to write a heap sort program usin pl-sql

Example of WRAP Operator - SQL The effect of Example can be obtained in SQL but note that one needs to write down not only the names of the columns being wrapped but also the