SQL Server与Oracle的数据类型对应表
SQL Server与Oracle的数据类型对应表
Microsoft Sql Server |
Oracle |
Comment |
BINARY |
RAW |
- |
BIT |
NUMBER(3) |
- |
CHAR |
CHAR |
- |
DATETIME |
DATE |
Fractional parts of a second are truncated |
DECIMAL |
NUMBER(p[,s]) |
- |
FLOAT |
FLOAT(49) |
- |
IMAGE |
LONG RAW |
- |
INTEGER |
NUMBER(10) |
NUMBER range is -2,147,483,647 to 2,147,483,647 |
MONEY |
NUMBER(19,4) |
- |
NCHAR |
CHAR |
- |
NTEXT |
LONG |
- |
NVARCHAR |
VARCHAR2 |
- |
NUMERIC |
NUMBER(p[,s]) |
- |
REAL |
FLOAT(23) |
- |
SMALL DATETIME |
DATE |
The value for seconds is returned as 0 |
SMALL MONEY |
NUMBER(10,4) |
- |
SMALLINT |
NUMBER(5) |
NUMBER range is -32,767 to 32,767 |
TEXT |
LONG |
- |
TIMESTAMP |
RAW |
- |
TINYINT |
NUMBER(3) |
- |
VARBINARY |
RAW |
- |
VARCHAR |
VARCHAR2 |
- |
