On this page

    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