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

SQL Server 数据类型

Oracle 数据类型

bigint

NUMBER

binary

LONG RAW NOT NULL

bit

NUMBER (1, 0)

char

VARCHAR2 (900) NOT NULL

datetime

DATE

decimal

NUMBER (255, 3) NOT NULL

float

FLOAT NOT NULL

image

LONG RAW

int

NUMBER (255, 3) NOT NULL

money

NUMBER (255, 3) NOT NULL

nchar

VARCHAR2 (2000) NOT NULL

ntext

LONG

numeric

NUMBER (255, 3) NOT NULL

nvarchar

VARCHAR2 (2000) NOT NULL

real

FLOAT NOT NULL

smallint

NUMBER (255, 3) NOT NULL

smalldatetime

DATE NOT NULL

smallmoney

NUMBER (255, 3) NOT NULL

sql_variant

LONG

sysname

CHAR(255)

text

LONG

timestamp

RAW (255)

tinyint

NUMBER (255, 3) NOT NULL