Mass Ingestion
- Mass Ingestion
- 所有产品
MySQLソースデータ型
| Oracleターゲットデータ型
|
---|---|
bigint
| number(19)
|
bigint unsigned
| number(20)
|
binary( size ), 1 <= size <= 255
| raw( size ), 1 <= size <= 255
|
bit( precision ), 1 <= p <= 64
| raw( size ), 1 <= size <= 8
|
blob
| blob
|
char( size ), 1 <= size <= 255
| varchar2(s char), 3 <= s <= 765
|
date
| date
|
datetime
| date
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
| number(p,s), 1 <= p <= 38, 0 <= s <= 29
|
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
| char(s char), 40 <= s <= 67
|
double
| binary_double
|
float
| binary_float
|
geomcollection
| blob
|
geometry
| blob
|
geometrycollection
| blob
|
int
| number(10)
|
int unsigned
| number(10)
|
json
| clob
|
linestring
| blob
|
longblob
| blob
|
longtext
| clob
|
mediumblob
| blob
|
mediumint
| number(7)
|
mediumint unsigned
| number(8)
|
mediumtext
| clob
|
multilinestring
| blob
|
multipoint
| blob
|
multipolygon
| blob
|
numeric(10,0)
| number(10)
|
point
| blob
|
polygon
| blob
|
smallint
| number(5)
|
smallint unsigned
| number(5)
|
text
| clob
|
time( precision ), 0 <= p <= 6
| char(s char), 10 <= s <= 17
|
timestamp( precision ), 0 <= p <= 6
| timestamp( precision ), 0 <= p <= 6
|
tinyblob
| raw(255)
|
tinyint
| number(3)
|
tinyint unsigned
| number(3)
|
tinytext
| varchar2(255 char)
|
varbinary( size ), 1 <= size <= 2000
| raw( size ), 1 <= size <= 2000
|
varbinary( size ), 2001 <= size <= 65535
| long raw
|
varchar( size ), 1 <= size <= 4000
| varchar2(s char), 3 <= s <= 4000
|
varchar( size ), 4001 <= size <= 21844
| clob
|
year
| number(4)
|