Q43
Which of the following is illegal?
A.
SELECT SYSDATE - SYSDATE FROM DUAL;
B.
SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
C.
SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
D.
None of these
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
SELECT SYSDATE - SYSDATE FROM DUAL; outputs 0
SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; outputs 2
SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; outputs -2