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
Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

Project Description: I am looking to change FullCalendar to add/delete sql server data when events are removed or dropped from Calendar. Events should only be included by dra

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illu

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de