SQL Server 和Oracle 数据类型对应

admin 运维工具 2023-02-27 1196浏览 0

SqlServer 2k转换为Oracle 10g

Oracle 10g 转换为SqlServer 2k

Oracle列名	Oracle数据类型	SqlServer列名	SqlServer数据类型	SqlServer数据长度
COLUMN1	BINARY_DOUBLE	COLUMN1	float	8
COLUMN2	BINARY_FLOAT	COLUMN2	real	4
COLUMN3	BLOB	COLUMN3	image	16
COLUMN4	CLOB	COLUMN4	ntext	16
COLUMN5	CHAR(10)	COLUMN5	nchar	10
COLUMN6	DATE	COLUMN6	datetime	8
COLUMN12	NUMBER	COLUMN12	numeric	13
COLUMN13	NVARCHAR2(10)	COLUMN13	nvarchar	10
COLUMN14	RAW(10)	COLUMN14	varbinary	10
COLUMN15	TIMESTAMP(6)	COLUMN15	datetime	8
COLUMN16	TIMESTAMP(6) WITH LOCAL TIME ZONE	COLUMN16	datetime	8
COLUMN17	TIMESTAMP(6) WITH TIME ZONE	COLUMN17	datetime	8
COLUMN18	VARCHAR2(10)	COLUMN18	nvarchar	10
COLUMN7	INTERVAL DAY(2) TO SECOND(6)	COLUMN7	nvarchar	30
COLUMN8	INTERVAL YEAR(2) TO MONTH	COLUMN8	nvarchar	14
COLUMN9	LONG	COLUMN9	ntext	16
COLUMN10	LONG RAW	COLUMN10	image	16
COLUMN11	NCLOB	COLUMN11	ntext	16