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
candidate key is subset of super key but not vice-verse explain
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is oracle datasource?
Difference between varchar and varchar2 data types?
How would you begin to troubleshoot an ORA-3113 error?
Differentiate between pre-select and pre-query?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is tns entry?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What are the attributes that are found in a cursor?
What is a subquery in oracle?
Explain the use of Merge statement in oracle 11g
Explain oracle left join with an example?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Can a parameter be passed to a cursor?