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
- 8632 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / nidhi
yes For Loop will be faster than the open fetch loop
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between sql and excel?
What is sql resultset?
What is ttitle and btitle?
what is meant by urlencode and urldocode? : Sql dba
What is spool?
Explain table and field in sql?
How to run sql statements with oracle sql developer?
How to call a javascript function from pl sql?
What is partition in sql query?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is composite primary key in sql?
What is the difference between null value, zero, and blank space?
Which is better trigger or stored procedure?
What is set serveroutput on in pl sql?
what are the features and advantages of object-oriented programming? : Sql dba
