Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please HELP about string function
On 5 août, 06:36, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "wajim" <waji..._at_hotmail.com> a écrit dans le message de news: 1186275792.494266.14..._at_22g2000hsm.googlegroups.com...
> > 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
The error message is :
SQL>Select TRANSLATE ('Where there are spaces put * and for tabs put
+', '
> | ', '*', ' ', '+')
> | >From dual;
SQL> Select "Where there are spaces put * and for tabs put +"
*
ERROR at line 1:
ORA-00972: identifier is too long
Received on Sun Aug 05 2007 - 04:18:16 CDT