The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8,2).
Evaluate this SQL statement:
SELECT TO_CHAR(unit_price, '$9,999') FROM product_information;
Which two statements are true about the output? (Choose two.)
The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8,2).
Evaluate this SQL statement:
SELECT TO_CHAR(unit_price, '$9,999') FROM product_information;
Which two statements are true about the output? (Choose two.)
The SQL statement uses the format '$9,999', which allows for a comma to separate thousands and a total of five digits, including the dollar sign. For a value 10235.95, it doesn't fit into this format and will lead to a display of #######, indicating an overflow error. For a value of 1023.99, TO_CHAR will round the value and it fits within the format, so it will be displayed as $1,024.
BD is correct
BD is the correct answer
Not sure why D is correct. Could someone explain please. Thanks
You have to change the format to '$99,999'