1z0-071 Oracle Database 12c SQL 第14题 NVL和TO_CHAR

Q14. View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.

Which SQL statement would produce the required result?

A. SELECT NVL(cust_credit_limit), ‘Not Available’) "NEW CREDIT"
FROM customers;
B. SELECT NVL(cust_credit_limit * .15), ‘Not Available’) "NEW CREDIT"
FROM customers;
C. SELECT TO_CHAR (NVL(cust_credit_limit * .15), ‘Not Available’) "NEW CREDIT"
FROM customers;
D. SELECT NVL (TO CHAR(cust_credit_limit * .15), ‘Not Available’) "NEW CREDIT"

FROM customers;

Correct Answer: D

Nvl（expr1，expr2） expr1 和 expr2 的数据类型必须一致