Db2 for LUW Source Data Type | Oracle Target Data Type |
|---|---|
bigint | number(19) |
binary(size), 1 <= size <= 255 | raw(size), 1 <= size <= 255 |
boolean | char(1 char) |
char for bit data | raw(1) |
char(size) for bit data, 2 <= size <= 255 | raw(size), 2 <= size <= 255 |
character(size), 1 <= size <= 255 | varchar2(s byte), 1 <= s <= 255 |
date | date |
decfloat(precision), 16 <= p <= 34 | varchar2(255 char) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | number(p,s), 1 <= p <= 31, 0 <= s <= 31 |
double | binary_double |
integer | number(10) |
long varchar | clob |
long varchar for bit data | blob |
real | binary_float |
smallint | number(5) |
time | timestamp(0) |
timestamp(0) | date |
timestamp(precision), 1 <= p <= 9 | timestamp(precision), 1 <= p <= 9 |
timestamp(precision), 10 <= p <= 12 | char(s char), 30 <= s <= 32 |
varbinary(size), 1 <= size <= 1501 | raw(size), 1 <= size <= 1501 |
varbinary(size), 2001 <= size <= 32672 | blob |
varchar(size) for bit data, 1 <= size <= 1501 | raw(size), 1 <= size <= 1501 |
varchar(size) for bit data, 2001 <= size <= 32672 | blob |
varchar(size), 1 <= size <= 3501 | varchar2(s byte), 1 <= s <= 3501 |
varchar(size), 4001 <= size <= 32672 | clob |