87.You want to display the date for the first Mon day of the next month and

87.You want to display the date for the first Mon day of the next month and 
issue the following command:


select 1 no from dual;




SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "is the first Monday for" fmmonth rrrr') FROM DUAL;


What is the outcome?
A.It executes successfully and returns the correct result.
B.It executes successfully but does not return the correct result.
C.It generates an error because TO_CHAR should be replaced with TO_DATE. 
D.It generates an error because fm and double quotation marks should not be used in the format string.
答案：A
解析：这道题说的是显示下个月的第一个星期一
SQL> SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "is the first Monday for" fmmonth rrrr') 
  2  FROM DUAL;


TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'DD
---------------------------------------------
04 is the first Monday for april 2016
--执行成功了
LAST_DAY(SYSDATE)指的是当月最后一天
NEXT_DAY(LAST_DAY(SYSDATE),'MON') 指的是从最后一天开始(不算该日期)第一个星期一
fmmonth :删除开头和结尾的空格
rrrr：完整的四位取整年份，其值取决于当前的年份