Oracleソースデータ型 | Oracleターゲットデータ型 |
|---|---|
binary_double | binary_double |
binary_float | binary_float |
blob | blob |
char(s byte), 1 <= size <= 2000 | char(s byte), 1 <= size <= 2000 |
char(s char), 1 <= size <= 2000 | char(s char), 1 <= size <= 2000 |
clob | clob |
date | date |
float(precision), 1 <= p <= 126 | float(precision), 1 <= p <= 126 |
integer | integer |
long raw | long raw |
long(2147483648 byte) | long(2147483648 byte) |
nchar(s char), 1 <= size <= 2000 | nchar(s char), 1 <= size <= 2000 |
nclob | nclob |
number | number |
number(*,s), -84 <= s <= 127 | number(*,s), -84 <= s <= 127 |
number(p,s), 1 <= p <= 38, -84 <= s <= 127 | number(p,s), 1 <= p <= 38, -84 <= s <= 127 |
nvarchar2(s char), 1 <= size <= 4000 | nvarchar2(s char), 1 <= size <= 4000 |
raw(size), 1 <= size <= 2000 | raw(size), 1 <= size <= 2000 |
rowid | rowid |
timestamp(precision) with time zone, 0 <= p <= 9 | timestamp(precision) with time zone, 0 <= p <= 9 |
timestamp(precision), 1 <= p <= 9 | timestamp(precision), 1 <= p <= 9 |
varchar2(s byte), 1 <= size <= 4000 | varchar2(s byte), 1 <= size <= 4000 |
varchar2(s char), 1 <= size <= 4000 | varchar2(s char), 1 <= size <= 4000 |
xml | clob |