How to do this?
From: <rajugaru.vij_at_gmail.com>
Date: Sat, 20 Apr 2013 13:48:06 +0000
Message-ID: 1507346407-1366465683-cardhu_decombobulator_blackberry.rim.net-44438923-_at_b28.c12.bise7.blackberry>
Hi all,
I just attended an interview, where I answered lot of questions, but struggled to answer only one.
Date: Sat, 20 Apr 2013 13:48:06 +0000
Message-ID: 1507346407-1366465683-cardhu_decombobulator_blackberry.rim.net-44438923-_at_b28.c12.bise7.blackberry>
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--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 20 2013 - 15:48:06 CEST