Oracle to Snowflake mapping

AutoSync maps Oracle object types to the following Snowflake column types:


Oracle object type	Snowflake column type
`char`	`varchar`
`varchar2`	`varchar`
`nchar`	`varchar`
`nvarchar2`	`varchar`
`number`	`number`
`number (without precision and scale)`	`float`
`float`	`float`
`binary_float`	`float`
`binary_double`	`float`
`long`	`varchar`
`long raw`	`binary`
`raw`	`binary`
`date`	`date`
`timestamp`	`timestamp_ntz`
`timestamp with time zone`	`timestamp_tz`
`timestamp with local time zone`	`timestamp_ntz`
`interval year to month`	`varchar`
`interval day to second`	`varchar`
`blob`	`binary`
`clob`	`varchar`
`nclob`	`varchar`
`bfile`	`binary`
`rowid`	`varchar`
`urowid`	`varchar`
`anydata`	`varchar`
`xmltype`	`varchar`