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 -> Please HELP about string function

Please HELP about string function

From: wajim <wajim29_at_hotmail.com>
Date: Sat, 04 Aug 2007 18:03:12 -0700
Message-ID: <1186275792.494266.14600@22g2000hsm.googlegroups.com>


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

Original text of this message

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