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

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

Question Posted / saswaticse65

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

How do I order columns in sql?

0 Answers  

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

What are the different ddl commands in sql?

0 Answers  

Does normalization improve performance?

0 Answers  

What is sql procedures and functions?

0 Answers  

What is the most restrictive isolation level? : Transact sql

0 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

What is your daily office routine?

0 Answers   Data Vision,

What is implicit cursor in pl sql?

0 Answers  

Mention what is the plv (pl/vision) package offers?

0 Answers  

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories