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


Please Help Members By Posting Answers For Below Questions

What is meant by joins?

630


How to connect to a local oracle 10g xe server?

541


How different is ms access and oracle?

558


What are the differences between char and varchar2 in oracle?

569


What is a partition in oracle?

550






What are the system predefined user roles?

593


Difference between cartesian join and cross join?

547


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1464


How to test null values?

684


How can you use check constraints for self referential integrity?

531


What are the logical operations?

681


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3837


What are the set operators union, union all, minus & intersect meant to do?

570


How to drop an index?

548


query optmization techniques and quwry analyser+projects+ppts

1940