The following table lists the data types supported by the Oracle driver and describes how they are mapped to the JDBC data types.

Table 1. Oracle Data Types
Oracle Data Type JDBC Data Type
BFILE BLOB
BINARY_DOUBLE 1 DOUBLE
BINARY_FLOAT 2 REAL
BLOB BLOB
CHAR CHAR
CLOB CLOB
DATE TIMESTAMP
FLOAT(n) DOUBLE
LONG LONGVARCHAR
LONG RAW LONGVARBINARY
NCHAR CHAR or NCHAR 3
NCLOB CLOB or NCLOB 4
NUMBER DECIMAL
NUMBER (p, s) DECIMAL
NVARCHAR2 VARCHAR or NVARCHAR 5
OBJECT STRUCT
RAW VARBINARY
TABLE ARRAY
TIMESTAMP 6 TIMESTAMP
TIMESTAMP WITH LOCAL TIME ZONE 7 TIMESTAMP
TIMESTAMP WITH TIME ZONE 8 VARCHAR or TIMESTAMP
UROWID 9 VARCHAR
VARCHAR2 10 VARCHAR
VARRAY ARRAY
XMLType 11 CLOB or SQLXML 12

For More Information:

1 Supported only for Oracle 10g and higher.
2 Supported only for Oracle 10g and higher.
3 When JDBCBehavior=0, the data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.
4 When JDBCBehavior=0, the data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.
5 When JDBCBehavior=0, the data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.
6 Supported only for Oracle9i and higher.
7 Supported only for Oracle9i and higher.
8 When FetchTSWTZasTimestamp=false (default), this data type is mapped to the JDBC VARCHAR data type; when FetchTSWTZasTimestamp=true, it is mapped to the JDBC TIMESTAMP data type.
9 Supported only for Oracle9i and higher.
10 Supported only for Oracle9i and higher.
11 Supports XMLType columns, except those with binary or object relational storage.
12 When JDBCBehavior=0, the data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.