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
- 9222 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
Which isolation level provides highest data integrity?
What is check constraint in db2?
What does reorg do in db2?
What is null in db2?
What is the maximum size of a char data type in db2?
Are views updateable?
Mention data types used in db2 ?
How do I import a csv file into db2?
What is dbrm? What it contains?
What is the physical storage length of the data types date, time, and timestamp?
What are the bind parameters ibm db2?
what is the responsibility of the construction superintendent
How to fetch the last row from the table in SQL (db2)?
What are db2 tables?
Define sqlca.
