Oracle

On this page

The following table explains how the Oracle datatypes are mapped to the target databases.

Oracle Datatype	Firebolt Datatype	Snowflake Datatype
Numbers
`NUMBER`	`NUMERIC`	`NUMBER`
`FLOAT`	`REAL`	`FLOAT`
`BINARY_FLOAT`	`REAL`	`FLOAT`
`BINARY_DOUBLE`	`DOUBLE`	`FLOAT`
Times
`DATE`	`TIMESTAMP`	`TIMESTAMP_NTZ`
`TIMESTAMP`	`TIMESTAMP`	`TIMESTAMP_NTZ`
`TIMESTAMP WITH TIME ZONE`	`TIMESTAMPTZ`	`TIMESTAMP_TZ`
`TIMESTAMP WITH LOCAL TIME ZONE`	`TIMESTAMP`	`TIMESTAMP_LTZ`
`INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND`	`TEXT`	`VARCHAR(64)`
Strings
`CHAR`	`TEXT`	`VARCHAR`
`NCHAR`	`TEXT`	`VARCHAR`
`VARCHAR2`	`TEXT`	`VARCHAR`
`NVARCHAR2`	`TEXT`	`VARCHAR`
`CLOB`	`TEXT`	`VARCHAR`
`NCLOB`	`TEXT`	`VARCHAR`
`(Any Oracle type not in the above list)`	`TEXT`	`VARCHAR(4000)`
Blobs
`RAW`	`BYTEA`	`BINARY`
`BLOB`	`BYTEA`	`BINARY`