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 -> CHAR TO NUMBER - NUMBER TO CHAR

CHAR TO NUMBER - NUMBER TO CHAR

From: Félix <fgaitero_at_e-netfinger.com>
Date: Fri, 28 Sep 2001 11:21:54 +0200
Message-ID: <9p1el6$nsi$1@talia.mad.ttd.net> 





I have to converse a datatype from CHAR(4):  '0004', to NUMBER: 4.  Then I
add 1 to this number: 4 + 1 = 5. I converse it to CHAR again but,  when I
select this value from the table I just get 5 and not 0005 as I want. It's
still a CHAR(4) but it appears only with one character and not four as it
should.


How could I do to obtain  '0005' and not '5' ?
Thanks.


Félix
Received on Fri Sep 28 2001 - 04:21:54 CDT












Original text of this message













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