skip to main content
DataDirect Connect Drivers : Oracle Driver : Data Types
  
Data Types
The following table lists the data types supported by the Oracle driver and describes how they are mapped to the JDBC data types.
Table 47. 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 SQLXM 12

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.

For More Information:
*See Using Date/Time Data Types for more information about the TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, and TIMESTAMP WITH TIME ZONE data types.
*See Using Collection Data Types for more information about the VARRAY, TABLE, and OBJECT data types.
*See Returning and Inserting/Updating XML Data for more information about the XMLType data type.
*Refer to "getTypeInfo()" in the DataDirect Connect Series for JDBC Reference for a description of the data types returned by the getTypeInfo() method.
* Using Date/Time Data Types
* Date/Time Session Parameters
* Using Collection Data Types