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 define in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to create additional tablespaces for an new database?
How to store only time; not date and time?
Which is faster join or subquery in oracle?
WHAT IS ecc 6.0
How to convert a string to a date in oracle database?
What are transaction isolation levels supported by oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
DBMS vs. RDBMS
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
Does a Before form trigger fire when the parameter form is suppressed ?