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?
- 4 Answers
- 7513 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
By the way, why to select a signle row using cursor then
delete, if you want to delete all the row mentioned in the
cursor search creteria, simply write a SQL query mentioning
delete where (matching search condition).
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is dbrm? When it will be created?
What is a collection in db2?
Is db2 a mainframe?
What are the two types of logging in the db2 database? Explain them.
What is cursor with hold option in db2?
How to compare data between two tables in db2?
Mention data types used in db2 ?
What is database alias db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Why db2 is called db2?
What is the connection string to connect to the DB2 Database ?
What is the default page size of buffer pools?
What is bind and rebind in db2?
What is coalesce in db2?
What is bind plan?
