Question:Which of the following SQL statements returns a numeric value? 

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; 

+ Answer
+ Report
Total Preview: 1429

Copyright © 2024. Powered by Intellect Software Ltd