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