What are cursor attributes?

Question Posted / guest

3 Answers
6426 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are cursor attributes?..

Answer / chandrasekar

%type
%rowtype

Is This Answer Correct ?

0 Yes

0 No

What are cursor attributes?..

Answer / dmk.java@gmail.com

%found
%notfound
%count
%isopen

Is This Answer Correct ?

0 Yes

0 No

What are cursor attributes?..

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

Post New Answer