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
Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

Use External Routines The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

MILLER-UREY' S EXPERIMENTAL PROCEDURES - They recreated the probable conditions on the primitive earth in the laboratory. An atmosphere containing hydrogen, ammonia, me

Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

Bulk Fetching The illustration below shows that you can bulk-fetch from a cursor into one or more collections: DECLARE TYPE NameTab IS TABLE OF emp.ename%TYPE; TYPE S

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut