Multiple choice technology databases

SELECT TO_CHAR(1000000, '$99,999.00') SALARY FROM dual What Is the Output?

  1. NNNNNNN

  2. ########

  3. 1000000

  4. 1000000.00

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When a number exceeds the format template width in Oracle's TO_CHAR function, the database displays pound signs (#) instead. The format '$99,999.00' only accommodates 5 digits before the comma, but 1,000,000 requires 7 digits, causing overflow.