Normal select Query fetches all rows in one go while cursor fetches one ro

what is the difference between normal select query and
currosor

Question Posted / vinay srivastava

Answer Posted / vinay srivastava

Normal select Query fetches all rows in one go while cursor
fetches one row at a time.

Is This Answer Correct ?

10 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What is check constraint in db2?

1163

Give the name of some fields form sqlca.

1142

What is check constraint. Explain with example.

1162

What are iseries servers?

1132

Explain the function of data manager.

1097

How to check last update on table in db2?

1097

What does db2 stand for?

1089

What is nvl in db2?

1147

Outputs of explain are with matchcols = 0. What does this signify?

1110

What is db2 catalog database?

1091

what are bind concepts in db2 cobol?

1137

Why do we use cursor?

1162

How to resolve deadlock issue

20318

How do I copy a table in db2?

1055

Which command is used to connect to a database in DB2 ? Give the Syntax.

1150