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

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task)
1) open - Fetch loop
2) for loop

Answer Posted / nidhi

yes For Loop will be faster than the open fetch loop

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger types in sql?

1040


how to concatenate two character strings? : Sql dba

1153


How do you declare a constant?

1013


what are sequences

1811


What does trigger mean in slang?

1119


what are the difference between clustered and a non-clustered index? : Sql dba

1080


What is structural independence and why is it important?

1071


What are the benefits of stored procedures?

1123


What is the maximum database size for sql express?

1069


What is data modelling in sql?

1068


How do I delete a trigger?

1012


What is primary key and unique key?

1160


Can a composite key be null?

1028


Why are sql stored procedures used?

1091


What is primary key in db?

1066