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
8453 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 use join in subquery?

1022

Which table is left in join?

914

How do you update sql?

912

what is view? : Sql dba

912

What are the different dcl commands in sql?

1065

What is PL/SQL Records?

1114

What are different functions in sql?

897

Is sql pronounced sequel or sql?

1213

what is 'trigger' in sql? : Sql dba

1012

What is row_number () in sql?

933

What is sql lookup?

864

How do I filter in sql profiler?

948

What is the purpose of the partition table?

1002

What are different types of statements supported by sql?

1096

what is the stuff function and how does it differ from the replace function? : Sql dba

989