Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1084


What is runstats db2?

1005


How do we specify index to include or not during bind process.

2108


What is buffer pool and list some of them?

1007


What is schema in db2?

1008


Explain about rct in db2?

1091


How to take backup of table in db2?

1058


What is the use of db2?

1037


On which levels locks can be applied?

1111


How to access db2 tables in mainframe?

1035


What do you mean by cursor?

979


What is rebind in db2?

1037


What is isolation level in db2?

983


Differentiate between cs and rr isolation levels? Where do you specify them?

1051


What is a db2 table?

990