Which is the correct output of the above query?

Evaluate the following SQL statements:
Exhibit:

Which is the correct output of the above query?

Evaluate the following SQL statements:
Exhibit:

Which is the correct output of the above query?

A.
+00-300, +54-02,+00 11:12:10.123457

B.
+00-300,+00-650,+00 11:12:10.123457

C.
+25-00, +54-02, +00 11:12:10.123457

D.
+25-00,+00-650,+00 11:12:10.123457



Leave a Reply 1

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


Peter

Peter

SQL> select interval ‘300’ month, interval ’54-2′ year to month, interval ’11:12:10.1234567′ hour to second from dual;

INTERVAL’300’MONTH
—————————————————————————
INTERVAL’54-2’YEARTOMONTH
—————————————————————————
INTERVAL’11:12:10.1234567’HOURTOSECOND
—————————————————————————
+25-00
+54-02
+00 11:12:10.123457
solution is correct here is the ckeck