to_char( 111, '099.99' ) : TO_CHAR Number « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. TO_CHAR Number

to_char( 111, '099.99' )

 
SQL>
SQL> select to_char( 111, '099.99' ) "NUMBER" from dual;

NUMBER
-------
 111.00

SQL>








Related examples in the same category

1.numerical format elements that can be used in format masks
2.Use To_Char function to format number in a select query
3.TO_CHAR(): return '#' if format is short
4.Use to_char( sal, '$9,999.99' ) to format a number type column to currency format
5.Without enough number symbols, Oracle is unable to return any output