默认数据类型映射

Oracle与虚谷数据库的默认数据类型映射如表1所示。

Oracle数据类型	Oracle列类型	Xugu数据类型	Xugu列类型
ROWID	ROWID	CHAR	CHAR
UROWID	UROWID	CHAR	CHAR
CHAR(size [BYTE | CHAR])	CHAR	CHAR	CHAR
NCHAR[(size)]	NCHAR	CHAR[(size)]	CHAR
VARCHAR(size [BYTE | CHAR])	VARCHAR2	VARCHAR	VARCHAR
VARCHAR2(size [BYTE | CHAR])	VARCHAR2	VARCHAR	VARCHAR
NVARCHAR2(size)	NVARCHAR2	VARCHAR	VARCHAR
NUMBER [(p [, s])]	NUMBER	NUMERIC	NUMERIC
NUMERIC [(p [, s])]	NUMBER	NUMERIC	NUMERIC
BINARY_DOUBLE	BINARY_DOUBLE	DOUBLE	DOUBLE
BINARY_FLOAT	BINARY_FLOAT	DOUBLE	DOUBLE
CLOB	CLOB	CLOB	CLOB
NCLOB	NCLOB	CLOB	CLOB
LONG	LONG	CLOB	CLOB
BLOB	BLOB	BLOB	BLOB
LONG RAW	LONG RAW	BLOB	BLOB
DATE	DATE	DATETIME	DATETIME
TIMESTAMP [(fractional_seconds_precision)]	TIMESTAMP	DATETIME	DATETIME
TIMESTAMP [(fractional_seconds_precision)] WITH TIME ZONE	TIMESTAMP WITH TIME ZONE	TIMESTAMP WITH TIME ZONE	TIMESTAMP WITH TIME ZONE
INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)]	INTERVAL DAY TO SECOND	INTERVAL DAY TO SECOND	-
INTERVAL YEAR [(year_precision)] TO MONTH	INTERVAL YEAR TO MONTH	INTERVAL YEAR TO MONTH	-