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.
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 的数据类型必须一致