| SQL Server 類型 | 長度 | Oracle 對應類型 |
|---|---|---|
| BIGINT | 8 | NUMBER(19) |
| BINARY | n | RAW(n) |
| BIT | 1 | NUMBER(2) |
| CHAR | n | CHAR(n) |
| DATETIME | 8 | DATE |
| DECIMAL/NUMERIC | p,s | NUMBER(p,s) |
| FLOAT | 8 | BINARY_DOUBLE |
| IMAGE | 16 | BLOB |
| INT | 4 | NUMBER(10) |
| MONEY | 8 | NUMBER(19,4) |
| NCHAR | n | NCHAR(n) |
| NTEXT | 16 | NCLOB |
| NVARCHAR | n | NVARCHAR2(n) |
| REAL | 4 | BINARY_FLOAT |
| SMALLDATETIME | 4 | DATE |
| SMALLINT | 2 | NUMBER(5) |
| SMALLMONEY | 4 | NUMBER(10,4) |
| SQL_VARIANT | - | BLOB |
| TEXT | 16 | CLOB |
| TIMESTAMP | 8 | RAW(8) |
| TINYINT | 1 | NUMBER(3) |
| UNIQUEIDENTIFIER | 16 | RAW(16) / CHAR(36) |
| VARBINARY | n | RAW(n) |
| VARCHAR | n | VARCHAR2(n) |
| Oracle 類型 | SQL Server 類型 | 長度 |
|---|---|---|
| BINARY_DOUBLE | FLOAT | 8 |
| BINARY_FLOAT | REAL | 4 |
| BLOB | IMAGE | 16 |
| CLOB | NTEXT | 16 |
| CHAR(n) | NCHAR | n |
| DATE | DATETIME | 8 |
| NUMBER | NUMERIC | 13 |
| NVARCHAR2(n) | NVARCHAR | n |
| RAW(n) | VARBINARY | n |
| TIMESTAMP(6) | DATETIME | 8 |
| TIMESTAMP(6) WITH LOCAL TIME ZONE | DATETIME | 8 |
| TIMESTAMP(6) WITH TIME ZONE | DATETIME | 8 |
| VARCHAR2(n) | NVARCHAR | n |
| INTERVAL DAY TO SECOND | NVARCHAR | 30 |
| INTERVAL YEAR TO MONTH | NVARCHAR | 14 |
| LONG | NTEXT | 16 |
| LONG RAW | IMAGE | 16 |
| NCLOB | NTEXT | 16 |
NUMBER 精度/標度需根據業務具體映射,不可一概而論。LONG/LONG RAW 已棄用,遷移至 CLOB/BLOB。TIMESTAMP WITH TIME ZONE) 在 SQL Server 需額外欄位存時區。