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 .

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