Teradataソースデータ型 | Oracleターゲットデータ型 |
|---|---|
array | blob |
bigint | number(19) |
blob | blob |
byte(precision), 1 <= p <= 64000 | blob |
byteint | number(3) |
char(size), 1 <= size <= 2000 | char(s byte), 1 <= s <= 2000 |
char(size), 2001 <= size <= 64000 | clob |
clob | clob |
date | date |
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 | number(p,s), 1 <= p <= 38, 1 <= s <= 37 |
float | binary_double |
integer | number(10) |
interval day(precision) to hour, 1 <= p <= 4 | char(s char), 5 <= s <= 8 |
interval day(precision) to minute, 1 <= p <= 4 | char(s char), 8 <= s <= 11 |
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | char(s char), 12 <= s <= 21 |
interval day(precision), 1 <= p <= 4 | char(s char), 2 <= s <= 5 |
interval hour(precision) to minute, 1 <= p <= 4 | char(s char), 5 <= s <= 8 |
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | char(s char), 9 <= s <= 18 |
interval hour(precision), 1 <= p <= 4 | char(s char), 2 <= s <= 5 |
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | char(s char), 9 <= s <= 18 |
interval minute(precision), 1 <= p <= 4 | char(s char), 2 <= s <= 5 |
interval month(precision), 1 <= p <= 4 | char(s char), 2 <= s <= 5 |
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6 | char(s char), 3 <= s <= 12 |
interval year(precision) to month, 1 <= p <= 4 | char(s char), 5 <= s <= 8 |
interval year(precision), 1 <= p <= 4 | char(s char), 2 <= s <= 5 |
json | clob |
mbr | blob |
number(*,s), 0 <= s <= 37 | char(255 char) |
number(p,s), 1 <= p <= 38, 1 <= s <= 37 | number(p,s), 1 <= p <= 38, 1 <= s <= 37 |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 | number(p,s), 1 <= p <= 38, 1 <= s <= 37 |
period(date) | char(28 char) |
period(time(precision) with time zone), 0 <= p <= 6 | char(s char), 36 <= s <= 50 |
period(time(precision) ), 0 <= p <= 6 | char(s char), 24 <= s <= 38 |
period(timestamp(precision) with time zone), 0 <= p <= 6 | char(s char), 58 <= s <= 72 |
period(timestamp(precision) ), 0 <= p <= 6 | char(s char), 46 <= s <= 60 |
smallint | number(5) |
time(precision) with time zone, 0 <= p <= 6 | timestamp(precision) with time zone, 0 <= p <= 6 |
time(precision), 0 <= p <= 6 | timestamp(precision), 0 <= p <= 6 |
timestamp(0) | date |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp(precision) with time zone, 0 <= p <= 6 |
timestamp(precision), 1 <= p <= 6 | timestamp(precision), 1 <= p <= 6 |
varbyte(precision), 1 <= p <= 64000 | blob |
varchar(size), 1 <= size <= 1501 | char(s byte), 1 <= s <= 1501 |
varchar(size), 2001 <= size <= 64000 | clob |
varray | blob |
xml | clob |