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

Re: CHAR TO NUMBER - NUMBER TO CHAR

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 28 Sep 2001 16:36:33 GMT
Message-ID: <9p28uh$gvj$1@netnews.upenn.edu> 





Michel Cadot (micadot_at_netcourrier.com) wrote:



: v817>select to_char(to_number('0004','0000')+1,'0000') from dual;




: TO_CH

: -----

:  0005




: 1 row selected.




The lpad function could solve it as well if michels quick/elegant 
solution doesn't your exact situation.
Received on Fri Sep 28 2001 - 11:36:33 CDT












Original text of this message













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