Which SQL statement would give the required result?

You need to display the date ll-oct-2007 in words as "Eleventh of October, Two Thousand Seven’. Which SQL statement would give the required result?
A. SELECT TO_CHAR(‘ll-oct-2007’. ‘miDdspth "of Month. Year’) FROM DUAL:
B. SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’X ‘miDdspth of month, year’) FROM DUAL;
C. SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’), ‘miDdthsp "of* Month. Year’) FROM DUAL;
D. SELECT TO_DATE(TO_CHAR(‘ll-oct-20077fiiiDdspth "of" Month. Year’)) FROM DUAL:

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.