Sqlserver類型 Oracle類型 binary RAW(50) bit NUMBER(2) char CHAR(10) datetime DATE decimal NUMBER(18) float BINARY_DOUBLE image BLOB int NUMBER(10) money N ...
| Sqlserver類型 | Oracle類型 |
| binary | RAW(50) |
| bit | NUMBER(2) |
| char | CHAR(10) |
| datetime | DATE |
| decimal | NUMBER(18) |
| float | BINARY_DOUBLE |
| image | BLOB |
| int | NUMBER(10) |
| money | NUMBER(19,4) |
| nchar | NCHAR(10) |
| ntext | NCLOB |
| numeric | NUMBER(18) |
| nvarchar | NVARCHAR2(50) |
| real | BINARY_FLOAT |
| smalldatetime | DATE |
| smallint | NUMBER(5) |
| smallmoney | NUMBER(10,4) |
| sql_variant | BLOB |
| text | CLOB |
| timestamp | RAW(8) |
| tinyint | NUMBER(3) |
| uniqueidentifier | BLOB |
| varbinary | RAW(50) |
| varchar | VARCHAR2(50) |
