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 -> to_char (33, '0009') adds an extra white space

to_char (33, '0009') adds an extra white space

From: Günther De Vogelaere <Gunther.DeVogelaere_at_NOSP@M.Ugent.be>
Date: Mon, 9 Jan 2006 14:03:23 +0100
Message-ID: <dptkje$8hb$1@gaudi2.UGent.be> 





Hi,



When I execute  'select '*' || to_char(33,'0009') || '*' from dual
I get '* 0033*' instead of '*0033*'.



Does anybody know what might be wrong? Something wrong in my configuration? 
Received on Mon Jan 09 2006 - 07:03:23 CST












Original text of this message













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