Learn about the data types by category, for example, numeric data and date data, that Oracle BI EE supports.
See Using the NQSGetSQLDataTypes Procedure to Access Data Type Information and Oracle BI EE Data Type Limitations.
Oracle BI EE supports three character data types.
The textual data types are:
CHAR
LONGVARCHAR
VARCHAR
Learn about the Oracle BI EE supported numeric data types.
Oracle BI EE supports the following numeric data types:
BIGINT
DECIMAL
DOUBLE
FLOAT
INTEGER
NUMERIC
REAL
SMALLINT
TINYINT