cursor attributes are %isopen ,%notfound,%found,%rowcount
but is any attributes there other than these? please tell me
asap ..
Answers were Sorted based on User's Feedback
Answer / b.chandan kumar patra
Yes there is another two attributes are there,
these are, %bulk attribute and another is %bulk rowcount.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / naresh
Yes the above answer is true, and te attributes that you
have mentioned are for explict cursor.
for implicit cursor just add SQL infront of all the attributes.
Like
SQL%isopen,
SQL%found
Cheers!
Naresh
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a nvl function? How can it be used?
What is object data modeling?
Explain oracle data types with examples?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
what is cartesian product?
How to set up autotrace for a user account?
Can multiple columns be used in group by in oracle?
How to insert multiple rows with one insert statement in oracle?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
How to get last row id?
What are steps required to ENTER DATA INTO DWH?
what is the difference between no rows returned and null returned?