View the Exhibit and examine the partial data in the PRODUCTS table.
PROD_ID is the primary key.
//IMG//
Examine the following code:
//IMG//
What is the outcome on execution of the above code?
- A.It executes successfully.
- B.It gives an error because the DECODE function can be used only in a SQL statement.
- C.It gives an error because the SUBSTR and INSTR functions can be used only in a SQL statement.
- D.It gives an error because both the MAX and DECODE functions can be used only in a SQL statement.