Re: Please HELP about string function

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 5 Aug 2007 06:36:18 +0200
Message-ID: <46b553c1$0$28617$426a34cc@news.free.fr>

"wajim" <wajim29_at_hotmail.com> a écrit dans le message de news: 1186275792.494266.14600_at_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...
|

Error? I don't see any error in your post.

SQL> Select TRANSLATE ('Where there are spaces put * and for tabs'||chr(9)||'put +',' '||chr(9),'*+') from dual; TRANSLATE('WHERETHEREARESPACESPUT*ANDFORTABS'||

---

Where*there*are*spaces*put***and*for*tabs+put*+

1 row selected.

Regards
Michel Cadot Received on Sat Aug 04 2007 - 23:36:18 CDT