Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> translate function
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-mailReceived on Wed May 15 2002 - 15:11:48 CDT
![]() |
![]() |