View the Exhibit and examine the structure of the CUSTOMERS table.
Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers. Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?
A. Option A
B. Option B
C. Option C
D. Option D
A is true
the correct is C, the arguments in the NVL can be of two different data types, there is no need for conversion. conversion is done implicitly
A
answer is A, the use of to_char of the first expression convert the default datatype of number so ‘not available’ is able to be parsed in.
C will return error as number dont accept ‘not available’ in its string format.
Correct answer A
Correct answer A
A