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 are sql functions? Describe the different types of sql functions?

1141


Compare sql & pl/sql

1131


What are the types of records?

988


Is inner join same as self join?

1108


What are actual parameters and formal parameters?

1101


Where not exists in sql?

975


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1086


Which are sql * plus commands?

1122


What are synonyms in sql?

967


What is the maximum database size for sql express?

1019


What is trigger explain with example?

1033


How to write a query to show the details of a student from students table whose

994


What is PL/SQL Records?

1182


Which is faster view or stored procedure?

940


When you have to use a default "rollback to" savepoint of plvlog?

1186