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...

Types of cursors and explanation each of them ?

Answer Posted / aditya

Ref cursor have two types strong ref cursor and weak ref cursor.

declaring a ref cursor and using it for multiple select statements is a weak cursor.

using a ref cursor as an out parameter to get a result set is a strong ref cursor.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cross join example?

1012


Explian rowid, rownum?

1018


What does pl sql stand for?

1120


What is program debugging?

1258


What is a pl/sql block?

1235


Does sql profiler affect performance?

998


what is the difference between inner and outer join? Explain with example. : Sql dba

1031


Why procedure is used in sql?

1041


what is log shipping? : Sql dba

1125


Are left and right joins the same?

1089


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1008


What is java sql connection?

1063


What operating systems are supported by oracle sql developer?

969


What are % type and % rowtype?

1035


how to do backup entire database? : Transact sql

1148