Data Types

This section shows equivalents between data types in Oracle and Snowflake, as well as some notes on arithmetic differences.

Oracle	Snowflake
ANSI Data Types	*Go to the link to get more information
BFILE	VARCHAR
BINARY_DOUBLE	FLOAT
BINARY_FLOAT	FLOAT
BLOB	BINARY
CHAR (N)	CHAR (N)
CLOB	VARCHAR
DATE	TIMESTAMP
FLOAT	FLOAT
INTERVAL YEAR TO MONTH	VARCHAR(20)
INTERVAL DAY TO SECOND	VARCHAR(20)
JSON	VARIANT
LONG	VARCHAR
LONG RAW	BINARY
NCHAR (N)	NCHAR (N)
NCLOB	VARCHAR
NUMBER(p, s)	NUMBER(p, s)
NVARCHAR2 (N)	VARCHAR (N)
RAW	BINARY
ROWID	VARCHAR(18)
VARCHAR2 (N)	VARCHAR (N)
SDO_GOMETRY	Currently not supported
SDO_TOPO_GEOMETRY	*to be defined
SDO_GEORASTER	*to be defined
SYS.ANYDATA	VARIANT
SYS.ANYDATASET	*to be defined
SYS.ANYTYPE	*to be defined
TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TIME ZONE	TIMESTAMP_TZ
TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMP_LTZ
URITYPE	*to be defined
UROWID	VARCHAR(18)
VARCHAR	VARCHAR
VARCHAR2	VARCHAR
XMLType	VARIANT

Notes on arithmetic operations

Please be aware that every operation performed on numerical datatypes is internally stored as a Number. Furthermore, depending on the operation performed it is possible to incur an error related to how intermediate values are stored within Snowflake, for more information please check this post on Snowflake's post on intermediate numbers in Snowflake.