Oracle to DB2 Datatypes

Lists class-level translations from Oracle datatypes to DB2 datatypes.

Class-Level Translation from Oracle to DB2 Datatypes

Oracle Datatype

DB2 Datatype

RAW

CHAR FOR BIT DATA

DATE

DATE

DATE (with time)

TIMESTAMP

FLOAT

DOUBLE (UNIX and Windows only)

INTEGER

INTEGER (UNIX and Windows only)

TIMESTAMP (9)

TIMESTAMP (UNIX and Windows only)