Re: to_char number format with optional decimal-point?

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 the output exceeds 64 characters. If the output exceeds 64 characters, then Oracle Database automatically returns the number in scientific notation.
Restrictions:

You cannot precede this element with any other element.
You can follow this element only with one 9 or one E (or e), but not with any
combination of these. The following statement returns an error:
SELECT TO_CHAR(1234, 'TM9e') FROM DUAL;

Pg 2-73 of the SQL Reference Manual :)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...