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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Types of cursors and explanation each of them ?

Question Posted / aditya

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 the 3 types of behavioral triggers?

1314

Is sql database free?

1029

What are sql built in functions?

981

What are the uses of merge?

1227

What is where clause in sql?

1088

What is the best partition size for windows 10?

1050

Can we join more than 2 tables in sql?

1094

Is t sql a programming language?

1115

what is a composite primary key ? : Sql dba

1095

What is substitution variable in pl sql?

1114

What is gpt format?

993

what is the command used to fetch first 5 characters of the string? : Sql dba

1685

What is the difference between sql, mysql and sql server?

1177

How do I run a sql script?

1233

What is scope and visibility in PL/SQL?

1291