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

write the Sql query for creating database backup?

7 Answers   TCS,

What are the two types of exceptions.

0 Answers  

What is right join in sql?

0 Answers  

what is sub-query? : Transact sql

0 Answers  

How can a pl sql block be executed?

0 Answers  

Explain the methods used to protect source code of pl/sql.

0 Answers  

What is the mutating table and constraining table?

0 Answers  

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

What are code pages ?

1 Answers   BirlaSoft,

Can you selectively load only those records that you need? : aql loader

0 Answers  

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories