SQL Server 和Oracle 数据类型对应

来源：互联网发布：数据库全书编辑：程序博客网时间：2024/05/21 09:18

SqlServer 2k转换为Oracle 10g

列名SqlServer数据类型SqlServer长度Oracle数据类型column1bigint8NUMBER(19)column2binary50RAW(50)column3bit1NUMBER(2)column4char10CHAR(10)column5datetime8DATEcolumn6decimal9NUMBER(18)column7float8BINARY_DOUBLEcolumn8image16BLOBcolumn9int4NUMBER(10)column10money8NUMBER(19,4)column11nchar10NCHAR(10)column12ntext16NCLOBcolumn13numeric9NUMBER(18)column14nvarchar50NVARCHAR2(50)column15real4BINARY_FLOATcolumn16smalldatetime4DATEcolumn17smallint2NUMBER(5)column18smallmoney4NUMBER(10,4)column19sql_variantBLOBcolumn20text16CLOBcolumn21timestamp8RAW(8)column22tinyint1NUMBER(3)column23uniqueidentifier16BLOBcolumn24varbinary50RAW(50)column25varchar50VARCHAR2(50)

Oracle 10g 转换为SqlServer 2k

Oracle列名Oracle数据类型SqlServer列名SqlServer数据类型SqlServer数据长度COLUMN1BINARY_DOUBLECOLUMN1float8COLUMN2BINARY_FLOATCOLUMN2real4COLUMN3BLOBCOLUMN3image16COLUMN4CLOBCOLUMN4ntext16COLUMN5CHAR(10)COLUMN5nchar10COLUMN6DATECOLUMN6datetime8COLUMN12NUMBERCOLUMN12numeric13COLUMN13NVARCHAR2(10)COLUMN13nvarchar10COLUMN14RAW(10)COLUMN14varbinary10COLUMN15TIMESTAMP(6)COLUMN15datetime8COLUMN16TIMESTAMP(6) WITH LOCAL TIME ZONECOLUMN16datetime8COLUMN17TIMESTAMP(6) WITH TIME ZONECOLUMN17datetime8COLUMN18VARCHAR2(10)COLUMN18nvarchar10COLUMN7INTERVAL DAY(2) TO SECOND(6)COLUMN7nvarchar30COLUMN8INTERVAL YEAR(2) TO MONTHCOLUMN8nvarchar14COLUMN9LONGCOLUMN9ntext16COLUMN10LONG RAWCOLUMN10image16COLUMN11NCLOBCOLUMN11ntext16

0 0