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 (TO CHAR(cust_credit_limit * .15), ‘Not Available’) “NEW CREDIT”
FROM customers;
B.
SELECT TO_CHAR (NVL(cust_credit_limit * .15), ‘Not Available’) “NEW CREDIT”
FROM customers;
C.
SELECT NVL(cust_credit_limit * .15), ‘Not Available’) “NEW CREDIT”
FROM customers;
D.
SELECT NVL(cust_credit_limit), ‘Not Available’) “NEW CREDIT”
FROM customers;
A. 1st and second parameter in NVL should be from compatible data types or available for implicit cast.