Microsoft SQL Server Source Data Type | Oracle Target Data Type |
|---|---|
bigint | number(19) |
binary(size), 1 <= size <= 2000 | raw(size), 1 <= size <= 2000 |
binary(size), 2001 <= size <= 8000 | blob |
bit | char(1 char) |
char(size), 1 <= size <= 2000 | char(s char), 1 <= size <= 2000 |
char(size), 2001 <= size <= 4000 | varchar2(s char), 2001 <= size <= 4000 |
char(size), 4001 <= size <= 8000 | clob |
date | date |
datetime | timestamp(3) |
datetime2(0) | date |
datetime2(precision), 1 <= p <= 7 | timestamp(precision), 1 <= p <= 7 |
datetimeoffset(precision), 0 <= p <= 7 | timestamp(precision) with time zone, 0 <= p <= 7 |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
float | binary_double |
geography | blob |
geometry | blob |
hierarchyid | blob |
image | blob |
int | number(10) |
money | number(19,4) |
nchar(size), 1 <= size <= 1000 | nchar(s char), 1 <= size <= 1000 |
nchar(size), 1001 <= size <= 2000 | nvarchar2(s char), 1001 <=size <= 2000 |
nchar(size), 2001 <= size <= 4000 | nclob |
ntext | nclob |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
nvarchar(size), 1 <= size <= 2000 | nvarchar2(s char), 1 <= size <= 2000 |
nvarchar(size), 2001 <= size <= 4000 | nclob |
real | binary_float |
smalldatetime | date |
smallint | number(5) |
smallmoney | number(10,4) |
sql_variant | blob |
text | clob |
time(precision), 0 <= p <= 7 | timestamp(precision), 0 <= p <= 7 |
timestamp(8) | raw(8) |
tinyint | number(3) |
uniqueidentifier | char(36 char) |
varbinary(size), 1 <= size <= 2000 | raw(size), 1 <= size <= 2000 |
varbinary(size), 2001 <= size <= 8000 | blob |
varchar(size), 1 <= size <= 4000 | varchar2(s char), 1 <= size <= 4000 |
varchar(size), 4001 <= size <= 8000 | clob |
xml | clob |