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
What is the maximum number of triggers that can be applied to a single table?
Explain the use of rows option in exp command.
Can multiple cursors being opened at the same time?
How will you identify oracle database software release?
How to use values from other tables in update statements using oracle?
How do we get field details of a table?
Why oracle is used?
What are a collation and state the different types of collation sensitivity?
How to define an oracle sub procedure?
How to view all columns in an existing table?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is tns service name?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What are the differences between char and varchar2 in oracle?
does the query needs a hint to access a materialized view?