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 Type | Dremio Type |
|---|---|
| BINARY_DOUBLE | DOUBLE |
| BINARY_FLOAT | FLOAT |
| BLOB | VARBINARY |
| CHAR | VARCHAR |
| DATE | DATE |
| FLOAT | DOUBLE |
| INTERVALDS | INTERVAL (day to seconds) |
| INTERVALYM | INTERVAL (years to months) |
| LONG RAW | VARBINARY |
| LONG | VARCHAR |
| NCHAR | VARCHAR |
| NUMBER | DECIMAL |
| NVARCHAR2 | VARCHAR |
| RAW | VARBINARY |
| TIMESTAMP | TIMESTAMP |
| VARCHAR2 | VARCHAR |