What are cursor attributes?
- 3 Answers
- 5904 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 |
Does jdbctemplate use prepared statements?
What is meant by jdbc and odbc?
Is jdbc and orm?
Is it possible to connect to multiple databases simultaneously?
Which interface handles transaction management in jdbc?
How many jdbc driver types are there?
Explain the difference between resultset and rowset in jdbc
r u used any design patterns in your project?
What is meant by dao?
What is the exception thrown by JDBC ?
Does JDBC support stored procedures?
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
Core Java 
