Oracle Source Data Type | Google BigQuery Target Data Type |
|---|---|
binary_double | float64 |
binary_float | float64 |
blob | bytes |
char(s byte), 1 <= size <= 2000 | string |
char(s char), 1 <= size <= 2000 | string |
clob | string |
date | datetime |
float(precision), 1 <= p <= 126 | string |
integer | string |
long raw | bytes |
long(2147483648 byte) | string |
nchar(s char), 1 <= size <= 2000 | string |
nclob | string |
number | string |
number(*,s), -84 <= s <= 127 | string |
number(1,-38) | bignumeric |
number(1,s), -37 <= s <= -29 | bignumeric |
number(1,s), -84 <= s <= -39 | string |
number(10,-29) | bignumeric |
number(11,-28) | bignumeric |
number(12,-27) | bignumeric |
number(13,-26) | bignumeric |
number(14,-25) | bignumeric |
number(15,-24) | bignumeric |
number(16,-23) | bignumeric |
number(17,-22) | bignumeric |
number(18,-21) | bignumeric |
number(19,-20) | bignumeric |
number(2,-37) | bignumeric |
number(20,-19) | bignumeric |
number(21,-18) | bignumeric |
number(22,-17) | bignumeric |
number(23,-16) | bignumeric |
number(24,-15) | bignumeric |
number(25,-14) | bignumeric |
number(26,-13) | bignumeric |
number(27,-12) | bignumeric |
number(28,-11) | bignumeric |
number(29,-10) | bignumeric |
number(3,-36) | bignumeric |
number(30,-9) | bignumeric |
number(31,-8) | bignumeric |
number(32,-7) | bignumeric |
number(33,-6) | bignumeric |
number(34,-5) | bignumeric |
number(35,-4) | bignumeric |
number(36,-3) | bignumeric |
number(37,-2) | bignumeric |
number(38,-1) | bignumeric |
number(38,s), 10 <= s <= 38 | bignumeric |
number(4,-35) | bignumeric |
number(5,-34) | bignumeric |
number(6,-33) | bignumeric |
number(7,-32) | bignumeric |
number(8,-31) | bignumeric |
number(9,-30) | bignumeric |
number(p,s), 1 <= p <= 38, -28 <= s <= 9 | numeric |
number(p,s), 1 <= p <= 38, -36 <= s <= 38 | bignumeric |
number(p,s), 1 <= p <= 38, -84 <= s <= 127 | string |
number(p,s), 2 <= p <= 3, -35 <= s <= 38 | bignumeric |
number(p,s), 2 <= p <= 3, -84 <= s <= 127 | string |
nvarchar2(s char), 1 <= s <= 4000 | string |
raw(size), 1 <= size <= 2000 | bytes |
rowid | string |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp |
timestamp(precision) with time zone, 7 <= p <= 9 | string |
timestamp(precision), 1 <= p <= 6 | datetime |
timestamp(precision), 7 <= p <= 9 | string |
varchar2(s byte), 1 <= size <= 4000 | string |
varchar2(s char), 1 <= size <= 4000 | string |
xml | string |