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

Home -> Community -> Usenet -> c.d.o.misc -> translate function

translate function

From: Luciano Belotto <luciano_at_nospam.com>
Date: 15 May 2002 20:11:48 GMT
Message-ID: <abufe4$qp5@dispatch.concentric.net>


I want to do something with translate function, i broke it down to this to ask my question:

select translate('abcdef', 'a', 'A') from dual; returns Abcdef, which is fine

But
select translate('abcdef', 'a', '') from dual; I would think this would return: bcdef but it just returns blank (or null?). Is this correct? Is there a way (or another similar, easy way) to get it to return what I want?

--
Luciano Belotto
replace spam with traxsoftware for e-mail
Received on Wed May 15 2002 - 15:11:48 CDT

Original text of this message

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