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
Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Comparison Operators Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to anot

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Definition of CROSS JOIN - SQL Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then: Note: Here T denotes Table

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

Dynamic SQL: The Most PL/SQL programs do a predictable, specific job. For illustration, a stored procedure may accept an employee number and salary increase, and then update t