Oracle Data Types

Dremio supports selecting the following Oracle Database types. The following table shows the mappings from Oracle to Dremio data types.

[info] Note: If a type is not present in the table, it is not currently supported.

Oracle Database Type Dremio Type
BINARY_DOUBLE double
BINARY_FLOAT float
DATE timestamp
FLOAT double
INTERVALDS integer (day to seconds)
INTERVALYM integer (years to months)
LONG RAW varbinary
LONG varchar
NCHAR varchar
NUMBER double
NVARCHAR2 varchar
RAW varbinary
TIMESTAMP timestamp
VARCHAR2 varchar

results matching ""

    No results matching ""