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...

suppose in my table 10 rows are there , i want to update odd
rows salary as 90000 ? how u do it ? any one help me ? what
do we use here cursor-fetch or normal sql ?

Answer Posted / saurabh

It can be achieved using the scroll able cursor along with the Relative option while updating the queue.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1092


What is a buffer in memory?

1052


What is plan in cobol db2?

1125


What is the physical storage length of time data type?

1113


What is an instance in db2?

1024


What is dclgen (declaration generator)?

1043


Explain package in db2 and its advantages?

1200


What are the various data types available in db2?

1078


What is database alias db2?

1112


Explain in brief how does db2 determine what lock-size to use?

1032


What does db2 mean?

1002


What is difference between isnull and coalesce?

1050


What is table space in db2?

1010


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?

9171


what is a corelated subquerry?

1117