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

Answers were Sorted based on User's Feedback



In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both l..

Answer / monika

for loop is faster then open -fetch loop

Is This Answer Correct ?    1 Yes 1 No

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both l..

Answer / nidhi

yes For Loop will be faster than the open fetch loop

Is This Answer Correct ?    0 Yes 0 No

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both l..

Answer / swastik

yes for loop is faster tan loop-fetch
in loop there is exit statement to control the loop
in for loop it is an implicitly declared integer which is incremented or decremented by 1 until the upper bound or lower bound is reached

Is This Answer Correct ?    0 Yes 0 No

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both l..

Answer / mihir kar

For loop is always faster than explicitly open -fetch loop.
the main advantages of for loop is it internally works like bulk collect limit 100
it hold 100 record and fetch so it is always preferebale.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a pl/sql block?

0 Answers  


What is Overloading of procedures ?

4 Answers   Amdocs,


What is a sql driver?

0 Answers  


What is pseudo column ?

6 Answers   ABB,


Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,


Can we use two order by clause in query?

0 Answers  


What is graph sql?

0 Answers  


How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,


What is pl/sql table? Why is it used?

0 Answers  


explain normalization concept? : Sql dba

0 Answers  


Why is partition used in sql?

0 Answers  


which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,


Categories