| 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 |
