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
- 9054 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / satty
first declare cursor and select the records you wanted and
then use delete statement with where current of your cursor.
becoz it will help you to delete that particular record
which has been choosed.
if any thing wrong plz intimate
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is difference between rollback and commit?
What are the various isolation levels possible?
What's The Error Code For Unique Index Voilation?
What is load replace in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to execute stored procedures?
What is the difference between db2 and oracle?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to resolve deadlock issue
What does reorg do in db2?
What is rct?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are db2 tables?
What is with ur in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
