Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Number to word convertion error

Re: Number to word convertion error

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 28 Apr 2005 08:54:22 -0700
Message-ID: <1114703662.197434.312490@f14g2000cwb.googlegroups.com> 





>>Hi,

>>I'm trying to spell out 1,721,131.31




sql> select to_char(


1721131.31,'999G999G999D00','nls_numeric_characters = ''.,''')
SPELL_OUT from dual;




SPELL_OUT





   1,721,131.31
Received on Thu Apr 28 2005 - 10:54:22 CDT












Original text of this message













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