Re: How to do this?
- From: timhall1@xxxxxxxxx
- To: rajugaru.vij@xxxxxxxxx,Oracle-L@xxxxxxxxxxxxx
- Date: Sat, 20 Apr 2013 14:04:16 +0000
Many possibilities, with DECODE and CASE being the most commonly used. When I
benchmarked them many years ago, DECODE was a tiny bit faster than CASE on my
systems/databases. Your mileage may vary...
Next, I would tell the interviewer I hope I could get a lock on the table and
had ample undo space available :)
HTH
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: rajugaru.vij@xxxxxxxxx
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Sat, 20 Apr 2013 13:48:06
To: <Oracle-L@xxxxxxxxxxxxx>
Reply-To: rajugaru.vij@xxxxxxxxx
Subject: How to do this?
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
