Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sushmita pathak
Whenever we work with explicit and implicit cursors
(including cursor variables), PL/SQL provides a set of
cursor attributes that return information about the cursor.
PL/SQL 8.1 adds another, composite attribute, SQL%
BULK_ROWCOUNT, for use with or after the FORALL statement.
All of the current attributes are as follows
cur %FOUND:
Returns TRUE if the last FETCH found a row
cur %NOTFOUND:
Returns FALSE if the last FETCH found a row
cur %ISOPEN:
Returns TRUE if the specified cursor is open
cur %ROWCOUNT:
Returns the number of rows modified by the DML statement
SQL%BULK_ROWCOUNT:
Returns the number of rows processed for each execution of
the bulk DML operation
In these attributes, cur is the name of an explicit cursor,
a cursor variable, or the string "SQL" for implicit cursors
(UPDATE, DELETE, and INSERT statements, since none of the
attributes can be applied to an implicit query). The %
BULK_ROWCOUNT structure has the same semantics as an index-
by table. The n th row in this pseudo index-by table stores
the number of rows processed by the n th execution of the
DML operation in the FORALL statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the considerations for deciding on transaction boundaries?
Describe odbc?
What is xe in oracle jdbc url?
The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?
What are the steps to connect to the database in java?
Which type of driver is unique in jdbc?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
What is a jdbc driver and how many jdbc drivers are available?
What are the three basic components of the odbc architecture?
Can we have foreign key reference to a non primary key column ?
Is jdbc and orm?
How does a custom RowSetReader get called from a CachedRowSet?
What is layer in communication?
What is the difference between setmaxrows(int) and setfetchsize(int)?
Explain the locking system in jdbc?
