for loop is faster then open -fetch loop

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

Question Posted / monika

4 Answers
8661 Views
JDA, I also Faced
E-Mail Answers

Answer Posted / monika

for loop is faster then open -fetch loop

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we insert in view in sql?

1060

What is pl sql quora?

1167

what are the different type of sql's statements ? : Sql dba

926

how to check server status with 'mysqladmin'? : Sql dba

1075

What is pl sql code?

1056

Why are cursors used?

1122

what are different types of collation sensitivity? : Sql dba

1067

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1227

What is the file extension for sql database?

1000

Explain how to use transactions efficiently : transact sql

980

differentiate between float and double. : Sql dba

1060

What is a primary key sql?

1044

What are the main features of cursor?

1071

What sql database should I use?

1145

How is a PL/SQL code compiled?

1236