Skip to main content

Oracle Data Types

Dremio supports Oracle data types, as shown in the following table which provides the mappings from Oracle to Dremio data types. If there are additional Oracle types not listed in the table, then those types are not supported in Dremio.

Oracle Data TypeDremio Type
BINARY_DOUBLEDOUBLE
BINARY_FLOATFLOAT
BLOBVARBINARY
CHARVARCHAR
DATEDATE
FLOATDOUBLE
INTERVALDSINTERVAL (day to seconds)
INTERVALYMINTERVAL (years to months)
LONG RAWVARBINARY
LONGVARCHAR
NCHARVARCHAR
NUMBERDECIMAL
NVARCHAR2VARCHAR
RAWVARBINARY
TIMESTAMPTIMESTAMP
VARCHAR2VARCHAR