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

Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.

Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

CLOSE Statement The CLOSE statement allows the resources held by a cursor variable or open cursor to be reused. No more rows can be fetched from the cursor variable or closed

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump i

Parameter and Keyword Description: dynamic_string: This is a string variable, literal, or expression which represents a SQL statement or the PL/SQL block. define_vari

Overriding Default Locking By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to you

THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

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