TO_CHAR Number « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. TO_CHAR Number
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
6.to_char( 111, '099.99' )