Which SQL statement returns a numeric value?
A.
 SELECT ROUND(hire_date) FROM EMP;
B.
 SELECT sysdate-hire_date FROM EMP;
C.
 SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
D.
 SELECT TO_NUMBER(hire_date + 7) FROM EMP;
Explanation:
Which SQL statement returns a numeric value?
Which SQL statement returns a numeric value?
A.
 SELECT ROUND(hire_date) FROM EMP;
B.
 SELECT sysdate-hire_date FROM EMP;
C.
 SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
D.
 SELECT TO_NUMBER(hire_date + 7) FROM EMP;
Explanation:
B
DATE value subtracted from a DATE value will return numeric value.