Ajay Nerumati

 Profile Answers by Ajay Nerumati 

• Jan 29th, 2007

 

you need three update statements for acheiving this task1. update set = 'delhi' where = 'temp' ;commit;2. update set = 'delhi' where = 'hyderabad' ;commit;3. update set = 'hyderabad' where = 'temp' ;commit;Please note that the commit is only a precaution , it can be used only once after all the three DML statements are run.Thank you,Ajay NerumatiOracle DBA

jkreddy

• Feb 4th, 2007

 

Hi its simple update statement.. update column city set city = 'delhi' where city ='hyderabad'this is it simple...bye JK

rams

• Feb 10th, 2007

 

hitry out the following queryupdate tablenameset city=case city when 'delhi' then 'hyderabad' when 'hyderabad' then 'delhi' else city end;

P.V.Deshpande

• Mar 27th, 2007

 

 update table_city  set city = (decode(city,'Delhi', 'Hydrabad','Delhi'))

sharmasl

 Profile Answers by sharmasl 

• Mar 5th, 2009

 

Update States set city= decode(city,`Delhi`,`Hyderabad`,`Hyderabad`,`Delhi`,city);

By using this query we can inter change the citys.

Thanks,
Salil Sharma

emraan

 Profile Answers by emraan 

• Dec 31st, 2009

 

update e set a = case a when 'city' then 'hyd' when 'hyd' then 'city' end

perfect and tested

Imran Baig

+91 - 9247519684