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
- 7806 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
Is sql similar to python?
What is the most restrictive isolation level? : Transact sql
what is isam? : Sql dba
What are all the common sql functions?
What type of database is cloud sql?
How do I run pl sql in sql developer?
What is pl sql script?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What does where 1 1 mean in sql?
Can a foreign key be a duplicate?
Which type of cursor is used to execute the dml statement?
How do I truncate a word?
What is sql deadlock?
What is clause in sql?
What is $$ in sql?
