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?
Answer options
A
SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers;
B
SELECT IFNULL(cust_credit_limit * 0.15,'Not Available') "NEW CREDIT" FROM customers;
C
SELECT NULLIF(cust_credit_limit*.15,'Not Available') "NEW CREDIT" FROM customers;
D
All the options
Correct answer: SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers;
Explanation
NVL with TO_CHAR conversion is correct Oracle syntax: NVL(TO_CHAR(expr), 'Not Available').