Discussion Forum : Oracle Sql Basics
Question - Which of the following is illegal?
Options:
A .  SELECT SYSDATE "“ SYSDATE FROM DUAL;
B .  SELECT SYSDATE "“ (SYSDATE "“ 2) FROM DUAL;
C .  SELECT SYSDATE "“ (SYSDATE + 2) FROM DUAL;
D .  None of the Mentioned
Answer: Option D


SELECT SYSDATE “ SYSDATE FROM DUAL; outputs 0 SELECT SYSDATE “ (SYSDATE “ 2) FROM DUAL; outputs 2
SELECT SYSDATE “ (SYSDATE + 2) FROM DUAL; outputs -2.



Was this answer helpful ?
Next Question
Submit Your Solution hear:

Your email address will not be published. Required fields are marked *