Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple SQL question

Re: Simple SQL question

From: Jeremy <jeremy0505_at_gmail.com>
Date: Fri, 3 Feb 2006 14:58:18 -0000
Message-ID: <MPG.1e4d7fe3ce4c4dd98a0e0@news.individual.net>


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?

-- 

jeremy
Received on Fri Feb 03 2006 - 08:58:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US