Mass Ingestion
- Mass Ingestion
- 所有产品
Netezzaソースデータ型
| Oracleターゲットデータ型
|
---|---|
bigint
| number(19)
|
boolean
| char(1 char)
|
byteint
| number(3)
|
char( size ), 1 <= size <= 3001
| varchar2(s char), 1 <= s <= 3001
|
char( size ), 4096 <= size <= 64000
| clob
|
date
| date
|
double
| binary_double
|
integer
| number(10)
|
interval
| varchar2(55 char)
|
nchar( size ), 1 <= size <= 901
| nvarchar2(s char), 1 <= s <= 901
|
nchar( size ), 1024 <= size <= 1100
| char(2000 char)
|
nchar( size ), 2100 <= size <= 16000
| clob
|
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
| number(p,s), 1 <= p <= 38, 1 <= s <= 38
|
nvarchar(1)
| nvarchar2(1 char)
|
nvarchar(1001)
| char(2000 char)
|
nvarchar( size ), 2001 <= s <= 16000
| clob
|
real
| binary_float
|
smallint
| number(5)
|
st_geometry( precision ), 1 <= p <= 1001
| raw( size ), 1 <= size <= 1001
|
st_geometry( precision ), 2001 <= p <= 63001
| blob
|
time
| timestamp(6)
|
timestamp
| timestamp(6)
|
timetz
| timestamp( precision ) with time zone, 6 <= p <= null
|
varbinary( size ), 1 <= size <= 1001
| raw( size ), 1 <= size <= 1001
|
varbinary( size ), 2001 <= size <= 64000
| blob
|
varchar( size ), 1 <= size <= 3001
| varchar2(s char), 1 <= s <= 3001
|
varchar( size ), 4001 <= size <= 64000
| clob
|