cursor attributes are %isopen ,%notfound,%found,%rowcount
but is any attributes there other than these? please tell me
asap ..
Answer Posted / 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 |
Post New Answer View All Answers
How to create a testing table in oracle?
Explain what are the uses of rollback segment?
How to count groups returned with the group by clause in oracle?
What is the simplest tool to run commands on oracle servers?
Why do we use bulk collect in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is index in Oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to export your own schema?
types of indexes and the rationale behind choosing a particular index for a situation.
How to resolve name conflicts between variables and columns?
Which is better Oracle or MS SQL? Why?
How to loop through data rows in the implicit cursor?
Explain user account with reference to oracle.