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 |