View the Exhibit and examine the structure of the 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.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
NVL FunctionConverts a null value to an actual value:
Data types that can be used are date, character, and number.
Data types must match:
– NVL(commission_pct, 0)
– NVL(hire_date, ’01-JAN-97′)
– NVL(job_id, ‘No Job Yet’)