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
- 4 Answers
- 8591 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is sql trigger example?
how to create a new table by selecting rows from another table in mysql? : Sql dba
How long does it take to learn pl sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
Can we use threading in pl/sql?
What is sql performance tuning?
What is a primary key? Explain
How many primary keys can a table have?
What is triggering circuit?
What does an inner join do?
How do I save a sql query?
How to get unique records from a table?
Is subquery faster than join?
How do I count duplicates in sql?
What is sql and also describe types of sql statements?
