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
Answer / nidhi
yes For Loop will be faster than the open fetch loop
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
What are the most important ddl statements in sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
can we delete the trigger in a view? if yes why if not why?
what is a composite key ? : Sql dba
How can you fetch first 5 characters of the string?
What is the difference between the sql*loader and import utilities? : aql loader
What are the types of join and explain each?
what is the difference between undefined value and null value? : Sql dba
In testing where do we use sql language and how it helps in testing?
What is the use of triggers?
What are the different ddl commands in sql?
How do you retrieve the second highest salary from a table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)