Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: to_char number format with optional decimal-point?
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