首页 071 正文

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE OF DATA TYPE DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week. Which query can be used?

2020.2.1 071 44

(EMPLOYEES表包含数据类型为NUMBER的EMP_ID列和数据类型为DATE的HIRE_DATE。您要显示自雇用以来六个月完成后的第一个星期一的日期。在会话中将NLS TERRITORY参数设置为AMERICA,因此,星期日是一周的第一天。可以使用哪个查询?)

A SELECT EMP_ID, NEXT_DAY (ADD MONTHS (HIRE_DATE, 6),’MONDAY’) FROM EMPLOYEES

B SELECT EMP_ID,ADD_MONTHS(HIRE DATE,6) NEXT DAY(‘MONDAY’) FROM EMPLOYEES

C SELECT EMP_ID, NEXT_DAY (MONTHS BETWEEN (HIRE_DATE, SYSDATE),6) FROM EMPLOYEES

D SELECT EMP_ID, NEXT_DAY ADD_MONTHS (HIRE_DATE, 6), 1) FROM EMPLOYEES

答案:A

相关推荐:

评论

昵称*

邮箱*

网址