Oracle源端映射到神通目的端

源数据类型	精度	小数位	长度	目的数据类型（默认）	精度	小数位	长度倍数	目的数据类型（可选）
CHAR				CHAR				VARCHAR|TEXT|CLOB
NCHAR				CHAR				VARCHAR|TEXT|CLOB
VARCHAR2				VARCHAR				CHAR|TEXT|CLOB
NVARCHAR2			0<=2L<=3999	VARCHAR				CHAR|TEXT|CLOB
NVARCHAR2			2L>=4000	CLOB				VARCHAR|CHAR|TEXT
VARCHAR				VARCHAR				CHAR|TEXT|CLOB
NUMBER	P<5	S=0		DECIMAL	P	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=5	S=0		DECIMAL	5	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	5<P<10	S=0		DECIMAL	P	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=10	S=0		DECIMAL	10	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	10<P<20	S=0		DECIMAL	P	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=20	S=0		DECIMAL	20	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	20<P<38	S=0		DECIMAL	P	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=*	S=0		NUMERIC	126	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION|DECIMAL
NUMBER	P=*	S>0		DECIMAL	126	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=*	S=0		DECIMAL	P+|S|	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=38	S=0		NUMERIC	126	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION|DECIMA
NUMBER	38<P<=126	S=0		DECIMAL	126	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P=0	S=0		DECIMAL	260	130		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P<=15	S>0		DECIMAL	P	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	15<P<=38	S>0		DECIMAL	max(P,S)	S		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	P<=15	S<0		FLOAT8				INT|SMALLINT|BIGINT|FLOAT|FLOAT4|DOUBLE PRECISION|DECIMAL
NUMBER	15<P<=38	S<0		DECIMAL	P+|S|	0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMBER	38<P<=126	S=-127		DOUBLE PRECISION		0		INT|SMALLINT|BIGINT|FLOAT|FLOAT4|FLOAT8
BINARY_FLOAT				FLOAT4				FLOAT|FLOAT8|INT|SMALLINT|BIGINT|DOUBLE PRECISION
BINARY_DOUBLE				FLOAT8				FLOAT|INT|SMALLINT|BIGINT|DOUBLE PRECISION
FLOAT	P<=15			FLOAT8				FLOAT|FLOAT4|INT|SMALLINT|BIGINT|DOUBLE PRECISION
FLOAT	16<=P<=53			FLOAT				FLOAT4|FLOAT8|INT|SMALLINT|BIGINT|DOUBLE PRECISION
FLOAT	53<P<127			DOUBLE PRECISION				FLOAT|FLOAT4|FLOAT8|INT|SMALLINT|BIGINT
LONG				CLOB
DATE				DATE				TIMESTAMP
TIMESTAMP				TIMESTAMP
INTERVAL				INTERVAL
RAW			0<=L<=2000	BINARY
LONG RAW				BLOB
BFILE				BLOB
BLOB				BLOB
CLOB				CLOB
NCLOB				CLOB
ROWID				CHAR			2
UROWID				VARCHAR			0.005
XMLTYPE				XMLTYPE				XML|CLOB