ocp 11g考题大全：1Z0-051-090题
ocp 11g考题大全：1Z0-051-090题，完整题库请点击这里联系老师咨询了解
90. Examine the structure and data in the PRICE_LIST table:
name Null Type
PROD_ID NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)
PROD_ID PROD_PRICE
100 $234.55
101 $6,509.75
102 $1,234
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;
Answer: C
试题解析：
A，prod_price为字符，不能*.25
B，TO_NUMBER(prod_price)里面需要转换格式
C 正确
D，本来(TO_NUMBER(prod_price,'$99,999.99')* .25已经是数值型，就不用再TO_NUMBER转换一回了。
精华阅读