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
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain the use of full option in exp command.
What are the different types of record groups in oracle? Explain each of them
Explain about integrity constraint?
What are the attributes of cursor?
Can a parameter be passed to a cursor?
How to write a left outer join with the where clause in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is dual table oracle?
Query to retrieve record for a many to many relationship ?
How do I start tns listener?
List the parts of a database trigger.
How to install oracle database 10g xe?
How to speed up webrick?
What is an oracle transaction?