DB2 to Oracle Datatypes

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

DB2 Datatype

Oracle Datatype

CHAR FOR BIT DATA

RAW

DATE

DATE

DECFLOAT UDB (UNIX and Windows only)

FLOAT

DOUBLE (UNIX and Windows only)

FLOAT

REAL (UNIX and Windows only)

REAL

TIME

DATE (with time)

TIMESTAMP

DATE (with time)

VARCHAR FOR BIT DATA

RAW