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: to_char number format with optional decimal-point?

Re: to_char number format with optional decimal-point?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 9 Aug 2006 13:14:11 -0700
Message-ID: <1155154451.592220.327050@75g2000cwc.googlegroups.com>


Frank van Bortel wrote:
> Martin T. schreef:
>
> > So ... finally stumbled upon the default format (why do the docs not
> > state this? grml ...)
> >
> TM TM The text minimum number format model returns (in decimal output)
> the smallest number of characters possible. This element is case
> insensitive.
> The default is TM9, which returns the number in fixed notation unless
> (snipped rest of doc)
> Pg 2-73 of the SQL Reference Manual :)
>

*I admit! I admit!*
Found it 30 minutes after posting the above statement. But I couldn't bear correcting me twice in the same thread ;)

(But really, I overlooked it twice before ... grml :)

best,
Martin Received on Wed Aug 09 2006 - 15:14:11 CDT

Original text of this message

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