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
- 9359 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
Explain dclgen.
What is meant by union and union all?
What type of database is db2?
How to find the number of rows in a db2 table?
What is the use of db2?
What is the physical storage length of the data types date, time, and timestamp?
What is rebind in db2?
What is the difference between oracle and db2?
Explain various types of locks in db2?
How can you count the number of rows from a table tab?
Who uses db2?
What is the purpose of rollback and commit?
How can we retrieve the total number of records in RPG & CLLE?
What is catalog database in db2?
When reorg is used?
