SQL Server与Oracle数据类型的对应关系

关于SQL Server与Oracle数据类型的对应关系可以通过下面的语句进行查询

 

SELECT * FROMmsdb.dbo.MSdatatype_mappings wheredbms_name='ORACLE';

 

类型	SQL Serer	Oracle	精度		是否支持null值
ORACLE	bigint	NUMBER	19	3	1
ORACLE	binary	BLOB	NULL	0	1
ORACLE	binary	RAW	-1	4	1
ORACLE	bit	NUMBER	1	3	1
ORACLE	char	CHAR	-1	4	1
ORACLE	char	CLOB	NULL	0	1
ORACLE	char	VARCHAR2	-1	4	1
ORACLE	date	DATE	NULL	0	1
ORACLE	datetime	TIMESTAMP	3	4	1
ORACLE	datetime2	TIMESTAMP	7	4	1
ORACLE	datetimeoffset	TIMESTAMP (7) WITH TIME ZONE	NULL	0	1
ORACLE	decimal	NUMBER	-1	3	1
ORACLE	double precision	FLOAT	NULL	0	1
ORACLE	float	FLOAT	NULL	0	1
ORACLE	geography	BLOB	NULL	0	1
ORACLE	geometry	BLOB	NULL	0	1
ORACLE	hierarchyid	BLOB	NULL	0	1
ORACLE	image	BLOB	NULL	0	1
ORACLE	int	NUMBER	10	3	1
ORACLE	money	NUMBER	19	3	1
ORACLE	nchar	NCHAR	-1	4	1
ORACLE	nchar	NCLOB	NULL	0	1
ORACLE	ntext	NCLOB	NULL	0	1
ORACLE	numeric	NUMBER	-1	3	1
ORACLE	nvarchar	NCLOB	NULL	0	1
ORACLE	nvarchar	NVARCHAR2	-1	4	1
ORACLE	nvarchar(max)	NCLOB	NULL	0	1
ORACLE	real	REAL	NULL	0	1
ORACLE	smalldatetime	DATE	NULL	0	1
ORACLE	smallint	NUMBER	5	3	1
ORACLE	smallmoney	NUMBER	10	3	1
ORACLE	sql_variant	NCLOB	NULL	0	1
ORACLE	sysname	NVARCHAR2	128	4	1
ORACLE	text	CLOB	NULL	0	1
ORACLE	time	VARCHAR2	16	4	1
ORACLE	timestamp	RAW	8	4	1
ORACLE	tinyint	NUMBER	3	3	1
ORACLE	uniqueidentifier	CHAR	38	4	1
ORACLE	varbinary	BLOB	NULL	0	1
ORACLE	varbinary	RAW	-1	4	1
ORACLE	varbinary(max)	BLOB	NULL	0	1
ORACLE	varchar	CLOB	NULL	0	1
ORACLE	varchar	VARCHAR2	-1	4	1
ORACLE	varchar(max)	CLOB	NULL	0	1
ORACLE	xml	NCLOB	NULL	0	1
ORACLE	bigint	NUMBER	19	3	1
ORACLE	binary	BLOB	NULL	0	1
ORACLE	binary	RAW	-1	4	1
ORACLE	bit	NUMBER	1	3	1
ORACLE	char	CHAR	-1	4	1
ORACLE	char	CLOB	NULL	0	1
ORACLE	char	VARCHAR2	-1	4	1
ORACLE	date	DATE	NULL	0	1
ORACLE	datetime	TIMESTAMP	3	4	1
ORACLE	datetime2	TIMESTAMP	7	4	1
ORACLE	datetimeoffset	TIMESTAMP (7) WITH TIME ZONE	NULL	0	1
ORACLE	decimal	NUMBER	-1	3	1
ORACLE	double precision	FLOAT	NULL	0	1
ORACLE	float	FLOAT	NULL	0	1
ORACLE	geography	BLOB	NULL	0	1
ORACLE	geometry	BLOB	NULL	0	1
ORACLE	hierarchyid	BLOB	NULL	0	1
ORACLE	image	BLOB	NULL	0	1
ORACLE	int	NUMBER	10	3	1
ORACLE	money	NUMBER	19	3	1
ORACLE	nchar	NCHAR	-1	4	1
ORACLE	nchar	NCLOB	NULL	0	1
ORACLE	ntext	NCLOB	NULL	0	1
ORACLE	numeric	NUMBER	-1	3	1
ORACLE	nvarchar	NCLOB	NULL	0	1
ORACLE	nvarchar	NVARCHAR2	-1	4	1
ORACLE	nvarchar(max)	NCLOB	NULL	0	1
ORACLE	real	REAL	NULL	0	1
ORACLE	smalldatetime	DATE	NULL	0	1
ORACLE	smallint	NUMBER	5	3	1
ORACLE	smallmoney	NUMBER	10	3	1
ORACLE	sql_variant	NCLOB	NULL	0	1
ORACLE	sysname	NVARCHAR2	128	4	1
ORACLE	text	CLOB	NULL	0	1
ORACLE	time	VARCHAR2	16	4	1
ORACLE	timestamp	RAW	8	4	1
ORACLE	tinyint	NUMBER	3	3	1
ORACLE	uniqueidentifier	CHAR	38	4	1
ORACLE	varbinary	BLOB	NULL	0	1
ORACLE	varbinary	RAW	-1	4	1
ORACLE	varbinary(max)	BLOB	NULL	0	1
ORACLE	varchar	CLOB	NULL	0	1
ORACLE	varchar	VARCHAR2	-1	4	1
ORACLE	varchar(max)	CLOB	NULL	0	1
ORACLE	xml	NCLOB	NULL	0	1
ORACLE	bigint	NUMBER	19	3	1
ORACLE	binary	BLOB	NULL	0	1
ORACLE	binary	RAW	-1	4	1
ORACLE	bit	NUMBER	1	3	1
ORACLE	char	CHAR	-1	4	1
ORACLE	char	CLOB	NULL	0	1
ORACLE	char	VARCHAR2	-1	4	1
ORACLE	date	DATE	NULL	0	1
ORACLE	datetime	VARCHAR2	27	4	1
ORACLE	datetime2	VARCHAR2	27	4	1
ORACLE	datetimeoffset	VARCHAR2	34	4	1
ORACLE	decimal	NUMBER	-1	3	1
ORACLE	double precision	FLOAT	NULL	0	1
ORACLE	float	FLOAT	NULL	0	1
ORACLE	geography	BLOB	NULL	0	1
ORACLE	geometry	BLOB	NULL	0	1
ORACLE	hierarchyid	BLOB	NULL	0	1
ORACLE	image	BLOB	NULL	0	1
ORACLE	int	NUMBER	10	3	1
ORACLE	money	NUMBER	19	3	1
ORACLE	nchar	CHAR	-1	4	1
ORACLE	nchar	CLOB	NULL	0	1
ORACLE	ntext	CLOB	NULL	0	1
ORACLE	numeric	NUMBER	-1	3	1
ORACLE	nvarchar	CLOB	NULL	0	1
ORACLE	nvarchar	VARCHAR2	-1	4	1
ORACLE	nvarchar(max)	CLOB	NULL	0	1
ORACLE	real	REAL	NULL	0	1
ORACLE	smalldatetime	DATE	NULL	0	1
ORACLE	smallint	NUMBER	5	3	1
ORACLE	smallmoney	NUMBER	10	3	1
ORACLE	sql_variant	CLOB	NULL	0	1
ORACLE	sysname	VARCHAR2	128	4	1
ORACLE	text	CLOB	NULL	0	1
ORACLE	time	VARCHAR2	16	4	1
ORACLE	timestamp	RAW	8	4	1
ORACLE	tinyint	NUMBER	3	3	1
ORACLE	uniqueidentifier	CHAR	38	4	1
ORACLE	varbinary	BLOB	NULL	0	1
ORACLE	varbinary	RAW	-1	4	1
ORACLE	varbinary(max)	BLOB	NULL	0	1
ORACLE	varchar	CLOB	NULL	0	1
ORACLE	varchar	VARCHAR2	-1	4	1
ORACLE	varchar(max)	CLOB	NULL	0	1
ORACLE	xml	CLOB	NULL	0	1
ORACLE	bigint	NUMBER	19	3	1
ORACLE	binary	BLOB	NULL	0	1
ORACLE	binary	RAW	-1	4	1
ORACLE	bit	NUMBER	1	3	1
ORACLE	char	CHAR	-1	4	1
ORACLE	char	CLOB	NULL	0	1
ORACLE	char	VARCHAR2	-1	4	1
ORACLE	date	DATE	NULL	0	1
ORACLE	datetime	TIMESTAMP	3	4	1
ORACLE	datetime2	TIMESTAMP	7	4	1
ORACLE	datetimeoffset	TIMESTAMP (7) WITH TIME ZONE	NULL	0	1
ORACLE	decimal	NUMBER	-1	3	1
ORACLE	double precision	FLOAT	NULL	0	1
ORACLE	float	FLOAT	NULL	0	1
ORACLE	geography	BLOB	NULL	0	1
ORACLE	geometry	BLOB	NULL	0	1
ORACLE	hierarchyid	BLOB	NULL	0	1
ORACLE	image	BLOB	NULL	0	1
ORACLE	int	NUMBER	10	3	1
ORACLE	money	NUMBER	19	3	1
ORACLE	nchar	NCHAR	-1	4	1
ORACLE	nchar	NCLOB	NULL	0	1
ORACLE	ntext	NCLOB	NULL	0	1
ORACLE	numeric	NUMBER	-1	3	1
ORACLE	nvarchar	NCLOB	NULL	0	1
ORACLE	nvarchar	NVARCHAR2	-1	4	1
ORACLE	nvarchar(max)	NCLOB	NULL	0	1
ORACLE	real	REAL	NULL	0	1
ORACLE	smalldatetime	DATE	NULL	0	1
ORACLE	smallint	NUMBER	5	3	1
ORACLE	smallmoney	NUMBER	10	3	1
ORACLE	sql_variant	NCLOB	NULL	0	1
ORACLE	sysname	NVARCHAR2	128	4	1
ORACLE	text	CLOB	NULL	0	1
ORACLE	time	VARCHAR2	16	4	1
ORACLE	timestamp	RAW	8	4	1
ORACLE	tinyint	NUMBER	3	3	1
ORACLE	uniqueidentifier	CHAR	38	4	1
ORACLE	varbinary	BLOB	NULL	0	1
ORACLE	varbinary	RAW	-1	4	1
ORACLE	varbinary(max)	BLOB	NULL	0	1
ORACLE	varchar	CLOB	NULL	0	1
ORACLE	varchar	VARCHAR2	-1	4	1
ORACLE	varchar(max)	CLOB	NULL	0	1
ORACLE	xml	NCLOB	NULL	0	1