Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple SQL question
In article <7ivvt1998ncc2f7q49r2s6lnc2inqr2l8n_at_4ax.com>, Andy Hassall
says...
> On Tue, 31 Jan 2006 15:27:28 -0800, DA Morgan <damorgan_at_psoug.org> wrote:
>
> >
> >Why is this discussion continuing? Translate will work in all
> >situations and is faster.
>
> TRANSLATE doesn't give the result the poster asked for.
>
> SQL> select translate('the cat sat on the mat', 'A ', 'A')
> 2 from dual;
>
> TRANSLATE('THECAT
> -----------------
> thecatsatonthemat
>
>
I was distracted for a while - does Daniel's solution using TRANSLATE not work? I am not familiar with TRANSLATE (I know it's not new but I never found the need to use until now (?))
So to get from:
'the cat sat on the mat'
to
'the cat sat on the mat'
using a TRANSLATE statement would be?
-- jeremyReceived on Fri Feb 03 2006 - 08:58:18 CST