Data Types

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

Oracle

Snowflake

*Go to the link to get more information

VARCHAR

FLOAT

FLOAT

BINARY

CHAR (N)

VARCHAR

TIMESTAMP

FLOAT

VARCHAR(20)

VARCHAR(20)

VARIANT

VARCHAR

BINARY

NCHAR (N)

VARCHAR

NUMBER(p, s)

VARCHAR (N)

BINARY

VARCHAR(18)

VARCHAR (N)

Currently not supported

*to be defined

*to be defined

VARIANT

*to be defined

*to be defined

TIMESTAMP

TIMESTAMP_TZ

TIMESTAMP_LTZ

*to be defined

VARCHAR(18)

VARCHAR

VARCHAR

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.

Last updated