Oracle Data Type and corresponding java type

Standard JDBC 1.0:

CHAR

Java. SQL. Types. CHAR

Java. lang. String

Oracle. SQL. CHAR

VARCHAR2

Java. SQL. Types. VARCHAR

Java. lang. String

Oracle. SQL. CHAR

LONG

Java. SQL. Types. LONGVARCHAR

Java. lang. String

Oracle. SQL. CHAR

NUMBER

Java. SQL. Types. NUMERIC

Java. math. BigDecimal

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. DECIMAL

Java. math. BigDecimal

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. BIT

Boolean

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. TINYINT

Byte

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. SMALLINT

Short

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. INTEGER

Int

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. BIGINT

Long

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. REAL

Float

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. FLOAT

Double

Oracle. SQL. NUMBER

NUMBER

Java. SQL. Types. DOUBLE

Double

Oracle. SQL. NUMBER

RAW

Java. SQL. Types. BINARY

Byte []

Oracle. SQL. RAW

RAW

Java. SQL. Types. VARBINARY

Byte []

Oracle. SQL. RAW

LONGRAW

Java. SQL. Types. LONGVARBINARY

Byte []

Oracle. SQL. RAW

Date

Java. SQL. types. Date

Java. SQL. Date

Oracle. SQL. Date

Date

Java. SQL. types. Time

Java. SQL. Time

Oracle. SQL. Date

Timestamp

Java. SQL. types. Timestamp

Javal. SQL. Timestamp

Oracle. SQL. Timestamp

Standard JDBC 2.0:

Blob

Java. SQL. types. blob

Java. SQL. blob

Oracle. SQL. blob

Clob

Java. SQL. types. clob

Java. SQL. clob

Oracle. SQL. clob

He was the author of the legal disclaimer, the legal representative of the legal representative.

Java. SQL. types. struct

Java. SQL. struct

Oracle. SQL. struct

Definition reference

Java. SQL. types. Ref

Java. SQL. Ref

Oracle. SQL. Ref

He was the author of the legal disclaimer, the legal representative of the legal representative.

Java. SQL. types. Array

Java. SQL. Array

Oracle. SQL. ARRAY

Oracle login capabilities:

BFILE

Oracle. jdbc. OracleTypes. BFILE

N/

Oracle. SQL. BFILE

ROWID

Oracle. jdbc. OracleTypes. ROWID

N/

Oracle. SQL. ROWID

REF CURSOR

Oracle. jdbc. OracleTypes. CURSOR

Java. SQL. ResultSet

Oracle. jdbc. OracleResultSet

TIMESTAMP

Oracle. jdbc. OracleTypes. TIMESTAMP

Java. SQL. Timestamp

Oracle. SQL. TIMESTAMP

TIMESTAMP WITH TIME ZONE

Oracle. jdbc. OracleTypes. TIMESTAMPTZ

Java. SQL. Timestamp

Oracle. SQL. TIMESTAMPTZ

TIMESTAMP WITH LOCAL TIME ZONE

Oracle. jdbc. OracleTypes. TIMESTAMPLTZ

Java. SQL. Timestamp

Oracle. SQL. TIMESTAMPLTZ