Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle10g: The oracle.sql.INTERVAL type
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,