SQLServer和Oracle数据类型对应SqlServer 2k转换为Oracle 10g
列名SqlServer数据类型SqlServer长度Oracle数据类型
column1bigint8NUMBER(19)
column2binary50RAW(50)
column3bit1NUMBER(2)
column4char10CHAR(10)
column5datetime8DATEoracle decimal类型
column6decimal9NUMBER(18)
column7float8BINARY_DOUBLE
column8image16BLOB
column9int4NUMBER(10)
column10money8NUMBER(19,4)
column11nchar10NCHAR(10)
column12ntext16NCLOB
column13numeric9NUMBER(18)
column14nvarchar50NVARCHAR2(50)
column15real4BINARY_FLOAT
column16smalldatetime4DATE
column17smallint2NUMBER(5)
column18smallmoney4NUMBER(10,4)
column19sql_variant BLOB
column20text16CLOB
column21timestamp8RAW(8)
column22tinyint1NUMBER(3)
column23uniqueidentifier16BLOB
column24varbinary50RAW(50)
column25varchar50VARCHAR2(50)
Oracle 10g 转换为SqlServer 2k
Oracle列名Oracle数据类型SqlServer列名SqlServer数据类型SqlServer数据长度COLUMN1BINARY_DOUBLE COLUMN1float8
COLUMN2BINARY_FLOAT COLUMN2real4
COLUMN3BLOB COLUMN3image16
COLUMN4CLOB COLUMN4ntext16
COLUMN5CHAR(10)COLUMN5nchar10
COLUMN6DATE COLUMN6datetime8
COLUMN12NUMBER COLUMN12numeric13
COLUMN13NVARCHAR2(10)COLUMN13nvarchar10
COLUMN14RAW(10)COLUMN14varbinary10
COLUMN15TIMESTAMP(6)COLUMN15datetime8
COLUMN16TIMESTAMP(6) WITH LOCAL TIME
ZONE COLUMN16datetime8
COLUMN17TIMESTAMP(6) WITH TIME ZONE COLUMN17datetime8
COLUMN18VARCHAR2(10)COLUMN18nvarchar10
COLUMN7INTERVAL DAY(2) TO SECOND(6)COLUMN7nvarchar30
COLUMN8INTERVAL YEAR(2) TO MONTH COLUMN8nvarchar14
COLUMN9LONG COLUMN9ntext16
COLUMN10LONG RAW COLUMN10image16
COLUMN11NCLOB COLUMN11ntext16

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。