Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: translate function
Luciano Belotto wrote:
> 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
The TRANSLATE function must have at least one valid value to replace with. You can not just do 'a' to '' you must do something like '0a' to '0'.
Daniel Morgan Received on Wed May 15 2002 - 15:50:55 CDT