Examine the structure and data in the PRICE_LIST table:
You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.
Which SQL statement would give the required result?
A. SELECT TO_CHAR (prod_price* .25, ‘$99,999.99’) FROM PRICE_LIST
B. SELECT TO_CHAR (TO_NUMBER(prod_price) * .25, ‘$99,999.00’) FROM PRICE_LIST
C. SELECT TO_CHAR (TO_NUMBER(prod_price, ‘$99,999.99’) * . 25, ‘$99,999.00’) FROM PRICE_LIST
D. SELECT TO_NUMBER (TO_NUMBER(prod_price, ‘$99,999.99’) * . 25, ‘$99,999.00’) FROM PRICE_LIST
C
C
C
B is the correct answer
result B:
ORA-01722: “invalid number”
*Cause: The specified number was invalid.
*Action: Specify a valid number.