Oracle Database SQL — Question 48

Which statement executes successfully?

Answer options

• A. SELECT TO_NUMBER(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;
• B. SELECT TO_CHAR(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;
• C. SELECT TO_NUMBER(TO_DATE(INTERVAL ‘800’ SECOND)) FROM DUAL;
• D. SELECT TO_DATE(TO_NUMBER(INTERVAL ‘800’ SECOND)) FROM DUAL;
• E. SELECT TO_DATE(INTERVAL ‘800’ SECOND, ‘HH24:MM’) FROM DUAL;

Correct answer: B

Explanation

Option B is correct because the TO_CHAR function can successfully convert the INTERVAL to a string format. The other options are incorrect due to inappropriate function usage; for instance, TO_NUMBER cannot process an INTERVAL directly, and TO_DATE is not suitable for converting INTERVAL values.