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
- 8984 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
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How do I delete a table in db2?
What are the various data types available in db2?
Which is faster delete or truncate?
What do you mean by between and in? Is between inclusive of specified range values?
What is nvl in db2?
What language is db2 written in?
How can you do the explain of a dynamic sql statement?
How would you find out the total number of rows in a db2 table?
what is a corelated subquerry?
What are catalog tables in db2?
What is package in db2 mainframe?
What is the maximum size of varchar data type in db2?
What is consistency token in db2?
How do I optimize a query in db2?
