Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Please HELP about string function
Hi all, can somebody help me with this string manip...
the question is:
Write a select statement that alters
'Where there are spaces put * and for tabs put +' TO 'Where*there*are*spaces*put***and*for*tabs+put*+'.
I have tried something but get an error message:
Select TRANSLATE ('Where there are spaces put * and for tabs put +', '
', '*', ' ', '+')
>From dual;
Thanks in advance... Received on Sat Aug 04 2007 - 20:03:12 CDT