Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

candidate key is subset of super key but not vice-verse explain

2107


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1955


What is oracle datasource?

1040


Difference between varchar and varchar2 data types?

1262


How would you begin to troubleshoot an ORA-3113 error?

2125


Differentiate between pre-select and pre-query?

1154


what is difference between sql plus and sql*plus? (not sql and sql plus).

3942


What is tns entry?

1236


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.

2143


What are the attributes that are found in a cursor?

1121


What is a subquery in oracle?

1167


Explain the use of Merge statement in oracle 11g

1076


Explain oracle left join with an example?

1063


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2313


Can a parameter be passed to a cursor?

1180