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 the usage of open cursor command?

1032

Is db2 a mainframe database?

942

Which component is used to execute the sql statements?

1051

Why do we need reorg in db2?

918

What is a collection in db2?

979

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1134

What is performance tuning db2?

1004

What is buffer pool and list some of them?

980

What is query_cache_limit?

927

How do you pull up a query which was previously saved in qmf?

1098

Explain about open switch business continuity software?

1070

How do I create a view in db2?

969

What is a cursor in programming?

1011

What is the use of predicate?

981

What is the syntax for FETCH in DB2 ?

1136