How to do this?

  • From: rajugaru.vij@xxxxxxxxx
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Sat, 20 Apr 2013 13:48:06 +0000

Hi all,
I just attended an interview, where I answered lot of questions, but struggled 
to answer only one. 

If I have a table which has a column gender, and I have only 'm' and 'f' in 
that, how to change all 'm's into 'f' and vise versa, with a single sql 
statement?

Any thoughts?

Sent on my BlackBerry® from Vodafone--
//www.freelists.org/webpage/oracle-l


Other related posts: