Discovery

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?

发布于 24 天前

(EMPLOYEES表包含数据类型为NUMBER的EMP_ID列和数据类型为DATE的HIRE_DATE。您要显示自雇用以来六个月 …