Oracle to Azure Synapse mapping

AutoSync maps Oracle object types to the following Azure Synapse column types:

Oracle object type Azure Synapse column type
char char
varchar2 varchar
nchar nchar
nvarchar2 nvarchar
number decimal
number (without precision and scale) float
float float
binary_float float
binary_double float
long varchar
long raw varchar
raw varchar
date date
timestamp datetime
timestamp with time zone datetimeoffset
timestamp with local time zone datetime
interval year to month varchar
interval day to second varchar
blob varchar
clob varchar
nclob nvarchar
bfile varchar
rowid varchar
urowid varchar
anydata varchar
xmltype varchar