Data Types Supported by Oracle Analytics

This topic contains a list by category of the data types that you can use with Oracle Analytics.

Binary Data

For more information about supported base data types, see Supported Data Types.

The supported binary data types are:

• BIT

• BINARY

• LONGVARBINARY

• VARBINARY

Date and Time Data

The supported date and time data types are:

• DATE

• TIME

• TIMESTAMP

Numeric Data

For information about DOUBLE and FLOAT, see Floating Point Limitations and Data Type Limitations.

The supported numeric data types are:

• BIGINT

• DECIMAL

• DOUBLE

• FLOAT

• INTEGER

• NUMERIC

• REAL

• SMALLINT

• TINYINT

Textual Data

The supported textual data types are:

• CHAR

• LONGVARCHAR

• VARCHAR