Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle10g: The oracle.sql.INTERVAL type

Oracle10g: The oracle.sql.INTERVAL type

From: <thomas_okken_at_hotmail.com>
Date: 5 Nov 2005 07:25:33 -0800
Message-ID: <1131204333.863117.24150@g49g2000cwa.googlegroups.com>


I have written a Java/JDBC-based database browser, and I would like to add support for the INTERVAL data type in Oracle10g. I noticed that the type returned is oracle.sql.INTERVAL, which can be displayed easily by simply calling toString(), but I have no information on how to modify or construct such an object.
When googling for oracle.sql.INTERVAL, I got a very unusual zero hits, and the JDBC programming examples that I did find all use awful stored-procedure contortions for working with this data type. I'm wondering, isn't there an easier way? Also, is there a place where I can get the full Javadoc for the Oracle10g JDBC driver (ojdbc14.jar)? It's easy enough to find the Javadoc for Oracle8i but I've had no luck with 10g so far.
Thanks for any insights,

Received on Sat Nov 05 2005 - 09:25:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US