Oracle-MSSQL 간 데이터 타입 변환 시 참고할만한 데이터 타입의 대한 표입니다.😊
| Microsoft SQL Server |
Oracle |
Comment |
| BIGINT |
NUMBER(19) |
|
| 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 |
NCHAR |
- |
| NTEXT |
LONG |
- |
| NVARCHAR |
NCHAR |
- |
| 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) |
- |
| UNIQUEIDENTIFIER |
CHAR(36) |
|
| VARBINARY |
RAW |
- |
| VARCHAR |
VARCHAR2 |
- |
출처 https://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm#i634210