The main difference between cursor FETCH and FOR LOOP is as below : In c

what is the difference between cursor FETCH and FOR LOOP ?

Question Posted / meher

3 Answers
25716 Views
CG-VAK, Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / meher

The main difference between cursor FETCH and FOR LOOP is as
below :
In case of cursor FETCH the cursor will open atleast once
but in case of cursor FOR LOOP the cursor will may or
maynot be open.

Is This Answer Correct ?

31 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which normal form is best?

948

What is row_number () in sql?

976

What will you get by the cursor attribute sql%notfound?

1053

What is substitution variable?

1042

What is online transaction processing (oltp)?

1015

What is set serveroutput on in pl sql?

1282

What is cursor in pl sql?

1108

Describe sql comments?

1026

How bulk collect improves performance?

995

What does cursor do in sql?

1011

Why should I use postgresql?

1007

Can you sum a count in sql?

993

What found sql?

938

what are tables and fields? : Sql dba

1037

How to connect a sql*plus session to an oracle server?

1118