Which statement will do this?
The SYSDATE function displays the current Oracle Server date as:
5/21/2019
You wish to display the date as:
MONDAY, 21 MAY, 2019
Which statement will do this?
A. SELECT TO_DATE(SYSDATE, ‘FMDAY, DD MONTH, YYYY’) FROM DUAL;
B. SELECT TO_CHAR(SYSDATE, ‘FMDD, DAY MONTH, YYYY’) FROM DUAL;
C. SELECT TO_CHAR(SYSDATE, ‘FMDAY, DDTH MONTH, YYYY’) FROM DUAL;
D. SELECT TO_CHAR(SYSDATE, ‘FMDAY, DD MONTH, YYYY’) FROM DUAL;
답 : D
'자격증 공부 > OCP' 카테고리의 다른 글
[1z0-071 v.2 ]3. Which two queries return rows for employees whose manager works in a different department? (1) | 2021.06.20 |
---|---|
[1z0-071 v.2] 2. Which queries generate the same output? (0) | 2021.06.19 |
댓글