What are cursors? Explain different types of cursors?
Answer Posted / vishnuvardhan reddy
in db2 there are two types of cursors
1.scrolable cursor
2.non scrolable cursor
scrolable cursor:
scrolable cursor can be moved in sequential
forword (or)backword direction in the resultant table.
Non scrolable cursor:
simplest cursor is the non scrolable cursor
it is always moved in a sequential direction.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What is dbms and its application?
What are the three types of database design?
Who are end users in dbms?
What is the database development process?
Explain about relational database management systems?
In which database can extended stored procedures be added?
Explain about the database management systems.
Explain about the relational database?
Explain what a database is?
How to use timestamp datatypes
Write the fastest query to find out how many rows exist in a table?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain the cube operator?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about network model?