Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursor attributes?
- 3 Answers
- 6537 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Is the JDBC-ODBC Bridge multi-threaded?
what is JDBC?
What is meant by connection string?
How can we store and retrieve images from the database?
What is a jdbctemplate?
What is an encrypted internet connection?
What is the function of setautocommit?
What is the function of drivermanager class?
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?
Which database is used with java?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
How many ways can you update a result set?
Core Java 
