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 / pandu

Hi Krishna, Actually your answer is ok but i have a small
doubt "he want to update odd rows salary as 9000" but in ur
answer i didn't find the odd rows.how will you divide that
table in odd rows and even rows? kindly tell me.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clone table?

999


How to resolve deadlock issue

19874


What is cursor in dbms?

1008


What is the difference between bind and rebind in db2?

1396


How to execute stored procedures?

1069


What is the syntax for creating a table in the db2 database?

1060


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1005


What are union and union all?

921


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1027


what is db2 restart?

2104


Why do we need reorg in db2?

924


Is db2 a programming language?

985


What are the bind parameters ibm db2?

991


What is a collection in db2?

986


What is the role of union all and union

1071