Oracle
1Z0-061 · Question #191
Examine the structure and data in the PRIC E_LIST table: Name Null? Type ------------ ------------- ------------------- PROD_D NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD PRICE…
The correct answer is C. SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM. See the full explanation below for the reasoning.
Question
Examine the structure and data in the PRIC E_LIST table:
Name Null? Type ------------ ------------- ------------------- PROD_D NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD PRICE ----------- ------------------------ 100 $234.55 101 $6, 509.75 102 $1, 234 in the same format as the PROD_PRICE. Which SQL statement would give the required result?
Options
- ASELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:
- B. SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;
- CSELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM
- DSELECT TO_NUMBER(TO_NUMBER(prod_price., $99.999.99')* .25/$99.999.00') FROM
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C79% (23)
- D7% (2)
Community Discussion
No community discussion yet for this question.