The PRODUCTS table has the following structure: Evaluate the following two SQL
statements: Which statement is true regarding the outcome?
A.
Only the first SQL statement executes successfully
B.
Both the statements execute and give the same result
C.
Both the statements execute and give different results
D.
Only the second SQL statement executes successfully
why doble quotes on first query?
no idea
In First query it is not double quote .It is two single quote.
SQL> select nvl2( sysdate,sysdate+15 ,”) from dual;
NVL2(SYSD
———
20-JAN-17
SQL> select nvl( sysdate,sysdate+15 ) from dual;
NVL(SYSDA
———
05-JAN-17
Both executes Sucecessfully but gives different results.