Data Type Categories Supported by Oracle BI EE

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 for information about specific data types.

Textual Data

Oracle BI EE supports three character data types.

The textual data types are:

• CHAR

• LONGVARCHAR

• VARCHAR

Numeric Data

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

Date and Time Data

Oracle BI EE supports these data and time data types.

• DATE

• TIME

• TIMESTAMP

Binary Data

Oracle BI EE supports numerous binary data types.

The supported binary data types are:

• BIT

• BINARY

• LONGVARBINARY

• VARBINARY