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 an oracle data file?
How to return top 5 rows in oracle?
How do you bind variables in oracle?
how to genarate random numbers in oracle for particular row?
Can we create trigger on view in oracle?
How to define a variable to match a table column data type?
What is different bet native dynamic sql and Dbms_Sql?
How to see free space of each tablespace?
which clause we are not used in where clause?
How to start a specific oracle instance?
Point out the difference between user tables and data dictionary?
25. Display the client number and the value of the highest value order placed by that client.