| 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 |
Oracle与SQL Server数据类型对应关系
关注
打赏
