If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT clause,which of these functions will be executed first?
A) TO_CHAR
B) SUBSTR
C) MONTH
D) YYYY

Question

​If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT clause,which of these functions will be executed first?
A) ​TO_CHAR
B) ​SUBSTR
C) ​MONTH
D) ​YYYY

Quizplus · Accepted Answer

TO_CHAR is executed first to convert the SYSDATE to a string in the specified format ('fmMONTH DD,YYYY'), which is then processed by SUBSTR.

​If a SELECT Statement Includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT Clause,which

If a SELECT Statement Includes SUBSTR(TO_CHAR(SYSDATE,'fmMONTH DD,YYYY'),-4,4)in the SELECT Clause,which