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 difference between cursor and trigger?

1017


Explain what is table in a database?

1003


What are different methods to trace the pl/sql code?

1047


What is union and union all keyword in sql and what are their differences?

1045


What's the difference between a primary key and a clustered index?

946


What is sql injection vulnerability?

869


What does pl sql stand for?

1063


What has stored procedures in sql?

992


What is the reports view in oracle sql developer?

924


Is left join faster than inner join?

1063


What is sql constant?

943


What is the difference between the sql*loader and import utilities? : aql loader

976


What is triggering circuit?

1015


What is snowflake sql?

1011


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

1039