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: decimal precision to string

Re: decimal precision to string

From: Thorsten Kettner <thorsten.kettner_at_web.de>
Date: 8 May 2007 04:48:20 -0700
Message-ID: <1178624900.249270.168970@o5g2000hsb.googlegroups.com> 





On 8 Mai, 12:01, Thorsten Kettner <thorsten.kett..._at_web.de> wrote:


>   select to_char(round(value * 100),'00009') from dual;

>   select to_char(value * 100,'00009') from dual;




Oops that was copy & paste. Format '00009' looks strange. Should be
'00000'.
Received on Tue May 08 2007 - 06:48:20 CDT












Original text of this message













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