Data Type Mapping in Oracle Database and Oracle Analytics
When you import metadata from an Oracle Database, the Semantic Modeler uses these mappings to determine the corresponding data type in the Oracle Analytics query engine for each imported column.
The mapping of data types from the Oracle Database to the Oracle Analytics query engine might differ depending on the database.
Oracle Database Data Type | Oracle Analytics Data Type |
---|---|
CHAR |
CHAR |
NCHAR |
CHAR |
VARCHAR2 |
VARCHAR |
NVARCHAR2 |
VARCHAR |
NUMBER (precision, scale) |
INT if scale = 0 and 1 <= precision <= 9; otherwise, same as NUMBER |
BINARY_FLOAT |
FLOAT |
BINARY_DOUBLE |
DOUBLE |
DATE |
DATETIME |
TIMESTAMP |
TIMESTAMP |
TIMESTAMP WITH TIME ZONE |
TIMESTAMP |
TIMESTAMP WITH LOCAL TIME ZONE |
TIMESTAMP |
BLOB |
LONGVARBINARY |
CLOB |
LONGVARCHAR |
NCLOB |
LONGVARCHAR |
BFILE |
Not supported |
LONG |
LONGVARCHAR |
LONG RAW |
Not supported |
ROWID |
CHAR |
XML Type |
LONGVARBINARY |
UriType |
Not supported |