Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8993 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 lock escalation in db2?
Can we insert update delete in view?
What is page size in db2?
How to test SQL -911 error while developing COB-DB2 program
What is db2? Explain.
Explain the contention situations caused by locks?
Explain what are the various isolation levels possible?
What is plan in cobol db2?
What is sqlca’s maximum length?
What does db2 stand for?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How to check last update on table in db2?
What is ibm db2 client?
What are bind parameters in db2?
Explain packages.
