TO_CHAR(12345.67, '99,999.9900') : Numeric Formatting « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. Numeric Formatting

TO_CHAR(12345.67, '99,999.9900')



SQL>
SQL>
SQL> SELECT TO_CHAR(12345.67, '99,999.9900') FROM dual;

TO_CHAR(1234
------------
 12,345.6700

SQL>








Related examples in the same category

1.Number Formatting
2.TO_CHAR(12345.67, '99999V99'): shift specified number of digits
3.TO_CHAR(12345.67, 'U99,999.99')
4.TO_CHAR(12345.67, '99999.99EEEE'): scientific notation
5.TO_CHAR(12345.67, '99999D99'): decimal point
6.TO_CHAR(12345.67, 'C99,999.99')
7.TO_CHAR(0.67, 'B9.99')
8.TO_CHAR(12345.67, '$99,999.99')
9.TO_CHAR(12345.67, '099,999.99')
10.TO_CHAR(-12345.67, '99,999.99') (2)
11.TO_CHAR(12345.67, '99999G99'): group separator
12.TO_CHAR(12345.67, 'TM')
13.TO_CHAR(2007, 'RN')
14.TO_CHAR(-12345.67, '99,999.99PR'): negative value in angle brackets
15.TO_CHAR(12345.67, 'L99,999.99' ): currency symbol
16.TO_CHAR(0012345.6700, 'FM99999.99')
17.TO_CHAR(-12345.67, '99,999.99MI')
18.TO_CHAR(product_price, '$9,999.00')