Sunday, 26 August 2012

Which SQL statement returns a numeric value? | Oracle

A. SELECT ADD_MONTHS(MAX (hire_date), 6) FROM EMP;
B. SELECT ROUND(hire_date)FROM EMP;
C. SELECT sysdate-hire_date FROM EMP;
D. SELECT TO_NUMBER(hire_date + 7)FROM EMP;

Ans:C

No comments: