by using cursors , we can access particular records from
the table based on some condition, i want to delete those
selected records, how can we write a query for this in the
program?
Answer Posted / vaneesh khurana
Hi Satty
Can you please let us know what command you will use for
delete.
Vaneesh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What action db2 takes when a program aborts in the middle of a transaction?
Explain about dbrm.
Before you give the explain statement, what are the prerogatives?
What is cursor with hold option in db2?
What is a buffer in memory?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the use of commit in db2?
How many databases are there?
What is dbrm library?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is scrollable cursor in db2?
What is the role of data manager in the db2 database?
What do you mean by commit and rollback?
What is innodb buffer pool?
What is the difference between bind and rebind in db2?