文档中心>数据集成>附录>任务类型转换>离线任务>Oracle 数据类型转换(离线)

Oracle 数据类型转换(离线)

最近更新时间:2024-07-09 22:01:41

我的收藏

读取

Oracle 数据类型
内部类型
NUMBER,INTEGER,INT,SMALLINT
Long
NUMERIC,DECIMAL,FLOAT,DOUBLE PRECISION,REAL
Double
LONG,CHAR,NCHAR,VARCHAR,VARCHAR2,NVARCHAR2,CLOB,NCLOB,CHARACTER,CHARACTER VARYING,CHAR VARYING,NATIONAL CHARACTER,NATIONAL CHAR,NATIONAL CHARACTER VARYING,NATIONAL CHAR VARYING,NCHAR VARYING
String
TIMESTAMP,DATE
Date
bit, bool
Boolean
BLOB,BFILE,RAW,LONG RAW
Bytes

写入

内部类型
Oracle 数据类型
Long
NUMBER,INTEGER,INT,SMALLINT
Double
NUMERIC,DECIMAL,FLOAT,DOUBLE PRECISION,REAL
String
LONG,CHAR,NCHAR,VARCHAR,VARCHAR2,NVARCHAR2,CLOB,NCLOB,CHARACTER,CHARACTER VARYING,CHAR VARYING,NATIONAL CHARACTER,NATIONAL CHAR,NATIONAL CHARACTER VARYING,NATIONAL CHAR VARYING,NCHAR VARYING
Date
TIMESTAMP,DATE
Boolean
bit, bool
Bytes
BLOB,BFILE,RAW,LONG RAW