Parameter and keyword description - sql cursor, PL-SQL Programming

Parameter and Keyword Description:

SQL:

This SQL is the name of the implicit SQL cursor.

%FOUND:

This attribute results TRUE if an INSERT, DELETE, or UPDATE statement affected one or more rows or a SELECT INTO statement returned one or more rows. Or else, it results FALSE.

%ISOPEN:

This attribute always results FALSE as the Oracle closes the SQL cursor automatically after executing its related SQL statement.

%NOTFOUND:

This attribute is the logical reverse of the %FOUND. It results TRUE if an INSERT, DELETE, or UPDATE statement affect no rows, or the SELECT INTO statement returned no rows. Or else, it results FALSE.

%ROWCOUNT:

This attribute results the number of rows affected by an INSERT, DELETE, or UPDATE statement, or returned by the SELECT INTO statement.

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







Related Discussions:- Parameter and keyword description - sql cursor, Assignment Help, Ask Question on Parameter and keyword description - sql cursor, Get Answer, Expert's Help, Parameter and keyword description - sql cursor Discussions

Write discussion on Parameter and keyword description - sql cursor
Your posts are moderated
Related Questions
Example of WHEN or THEN Constraints A concrete example showing how SQL supports WHEN/THEN constraints CREATE TABLE SAL_HISTORY (EmpNo CHAR (6), Salary INTEGER NOT NULL,

Assignments in pl/sql The Variables and constants are initialized every time a block or subprogram is entered. By default, the variables are initialized to NULL. Therefore, unle

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

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Example of DELETE - SQL As with UPDATE, a FOR PORTION OF clause can be specified if the target table has a defined period name, as illustrated in Example. Example: Deleting

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

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons: