EXEMPLOS DE FORMATAÇÃO DE VALORES

TO_CHAR() Function                                                         Resultado

TO_CHAR(12345.67, '99999.99')          12345.67

TO_CHAR(12345.67, '99,999.99')         12,345.67 

TO_CHAR(-12345.67, '99,999.99')        -12,345.67 
TO_CHAR(12345.67, '099,999.99')        012,345.67 
TO_CHAR(12345.67, '99,999.9900')       12,345.6700 
TO_CHAR(12345.67, '$99,999.99')        $12,345.67 
TO_CHAR(0.67, 'B9.99')                 .67 
TO_CHAR(12345.67, 'C99,999.99')        USD12,345.67

TO_CHAR(12345.67, '99999D99')          12345.67

TO_CHAR(12345.67, '99999.99EEEE')      1.23E+04

TO_CHAR(0012345.6700, 'FM99999.99')    12345.67

TO_CHAR(12345.67, '99999G99')          123,46

TO_CHAR(12345.67, 'L99,999.99')        $12,345.67

TO_CHAR(-12345.67, '99,999.99MI')      12,345.67

TO_CHAR(-12345.67, '99,999.99PR')      12,345.67

TO_CHAR(2007, 'RN')                    MMVII

TO_CHAR(12345.67, 'TM')                12345.67

TO_CHAR(12345.67, 'U99,999.99')        $12,345.67

TO_CHAR(12345.67, '99999V99')          1234567

TO_CHAR(12345.67,'FM999G990D00')       12.345,67
to_char(12345.67,'FM999990D00')        12345,67