TO_CHAR(): return '#' if format is short : TO_CHAR Number « Data Type « Oracle PL / SQL






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

TO_CHAR(): return '#' if format is short


SQL>
SQL>
SQL> -- TO_CHAR(): return '#' if format is short
SQL>
SQL> SELECT TO_CHAR(12345678.90, '99,999.99') FROM dual;

TO_CHAR(12
----------
##########

SQL>
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.Use to_char( sal, '$9,999.99' ) to format a number type column to currency format
4.Without enough number symbols, Oracle is unable to return any output
5.to_char( 111, '099.99' )