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

Can a commit statement be executed as part of a trigger?

1101


What are different joins used in sql?

1103


Mention what does the hierarchical profiler does?

1135


What is sql engine in oracle?

1038


how to use case expression? : Sql dba

1076


What is the starting oracle error number? What is meant by forward declaration in functions?

1040


Is sqlite good enough for production?

1045


What is an invalid partition table?

1064


How delete a row in sql?

1039


Explain the update statement in sql

1041


What is varray in pl sql?

1120


Explain what is a database?

1134


What are the different sql commands?

1126


What do you understand by case manipulation functions?

1077


What is information schema in sql?

1113