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
- 8777 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 procedure and function?
Is a table valued function object?
Is not null in sql?
Differentiate between sga and pga.
What is %rowtype in pl sql?
How do I write a cron which will run a sql query and mail the results to agroup?
What are variables in pl sql?
what is a foreign key ? : Sql dba
Can you call pl/sql package functions from within a fast formula?
What is acid property in a database?
What is rank () in sql?
Which is the correct statement about truncate and delete?
What is group function in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Is sql considered coding?
