Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17356 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jagan
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.
| Is This Answer Correct ? | 28 Yes | 5 No |
Answer / 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 |
can any one expalin check point with an example?
Which catalog table stores referential constraints?
What is dbrm? What it contains?
What is ibm db2 database?
Once you create a view, where would information about the view be stored?
How does db2 sample database connect?
What is the meaning of -805 SQL return code?
what are the bind parameters?
What is reorg?
What is drop table?
What is commit in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
COBOL 
