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
