218. Evaluate the following query:
SELECT INTERVAL '300' MONTH, INTERVAL '542' YEAR TO MONTH,
INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual;
What is the correct output of the above query?
A. +25-00, +54-02,+00 11:12:10.123457
B. +00-300,+54-02,+00 11:12:10.123457
C. +25-00, +00-650,+00 11:12:10.123457
D. +00-300, +00-650,+00 11:12:10.123457
Answer: A
Eg:
1: SELECT INTERVAL'300'MONTH, INTERVAL'54-2'YEAR TO MONTH,
INTERVAL'11:12:10.1234567' HOUR TO SECOND FROM dual;
+25-00
+54-02
+00 11:12:10.123457
2: SQL> SELECT INTERVAL'24'MONTH from dual;
+02-00
3: SELECT INTERVAL'25'MONTH from dual;
+02-01
4:SELECT INTERVAL'54-12'year to month from dual;
SELECT INTERVAL'54-12'year to month from dual
ORA-01843: 无效的月份 (注:月份是0-11之间的数字)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-719008/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
