What is the outcome?

You want to display the date for the first Monday of the next month and issue the following
command:
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),’MON’), ‘dd “is the first Monday
for”fmmonth rrrr’) FROM DUAL;
What is the outcome?

You want to display the date for the first Monday of the next month and issue the following
command:
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 rrrr should be replaced by rr in the format string.

E.
It generates an error because fm and double quotation marks should not be used in the format
string.

Explanation:
NEXT_DAY(date, ‘char’): Finds the date of the next specified day of the week (‘char’) following
date. The value of char may be a number representing a day or a character string.
LAST_DAY(date): Finds the date of the last day of the month that contains date
The second innermost function is evaluated next. TO_CHAR(’28-OCT-2009′, ‘fmMonth’) converts
the given date based on the Month format mask and returns the character string October. The fm
modifier trims trailing blank spaces from the name of the month.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Jason

Jason

SQL> SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),’MON’), ‘dd “is the first Monday
2 for”fmmonth rrrr’) FROM DUAL;
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),’MON’), ‘dd “is the first Monday
*
ERROR at line 1:
ORA-00911: invalid character

reach

reach

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),’MON’), ‘dd “is the first Monday for” fmmonth rrrr’) FROM DUAL

Works perfectly fine

riccia

riccia

To make it works rewrite the single and double quote.

mickael

mickael

ERROR at line 1:
ORA-00907: missing right parenthesis

mickael

mickael

works with rewrite single and double quote.