Sql cursor - syntax, PL-SQL Programming

SQL Cursor 

The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as the SQL cursor that has 4 attributes: %NOTFOUND, %FOUND, %ISOPEN, and %ROWCOUNT. They give you the helpful information about the execution of the data manipulation statements.

Syntax:

1937_sql cursor.png

Posted Date: 10/8/2012 8:06:19 AM | Location : United States







Related Discussions:- Sql cursor - syntax, Assignment Help, Ask Question on Sql cursor - syntax, Get Answer, Expert's Help, Sql cursor - syntax Discussions

Write discussion on Sql cursor - syntax
Your posts are moderated
Related Questions
Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

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

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

Indeterminacy in SQL Some SQL expressions are actually not function invocations at all in the mathematical sense, being indeterminate-invocations operating on identical input

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

heap sort program in pl/sql

Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Entering and Exiting If you enter the executable part of an autonomous routine, the major transaction suspends. When you exit the routine, the major transaction resumes. To ex