View the Exhibit and examine the details of the PRODUCT_INFORMATION table.
Evaluate the following SQL statement:
SELECT TO_CHAR(list_price,’$9,999′)
FROM product_information;
Which two statements would be true regarding the output for this SQL statement? (Choose two.)
A.
The LIST_PRICE column having value 1123.90 would be displayed as $1,124.
B.
The LIST_PRICE column having value 1123.90 would be displayed as $1,123.
C.
The LIST_PRICE column having value 11235.90 would be displayed as $1,123.
D.
The LIST_PRICE column having value 11235.90 would be displayed as #######.
Please explain why D is correct
For D, How does Oracle convert 11235.90 to “#######”??
SELECT TO_CHAR(10000,’$9,999.00′) FROM dual;
will return “######’