Oracle Certificate Profession 1Z0-051-19

LuiseDalian發表於2014-05-09
Oracle
（19）Evaluate the following query:

SELECT INTERVAL '300' MONTH, INTERVAL '54-2' 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

答案：（A）

解析：

《SQL Language Reference》  Literal

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1157184/，如需轉載，請註明出處，否則將追究法律責任。

相關文章