Dremio maps the following Oracle database types to Dremio data types:
| Oracle Database Type | Dremio Type |
|---|---|
| BINARY_DOUBLE | DOUBLE |
| BINARY_FLOAT | FLOAT |
| BLOB | VARBINARY |
| CHAR | BLOB |
| DATE | TIMESTAMP |
| 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 |