IBM DB2 Question:
Download Job Interview Questions and Answers PDF
what is the difference between normal select query and
currosor
Answer:
using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.
In case more than one row is retrieved in a select clause it
will throw -811 sql error.
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.
In case more than one row is retrieved in a select clause it
will throw -811 sql error.
Download IBM DB2 Interview Questions And Answers
PDF