Supported Data Types

Learn about the data types by category, for example, numeric data and date data.

See Supported Base Data Types in Administering Oracle Analytics Server.

Textual Data

Oracle Analytics Server supports three character data types.

The textual data types are:

  • CHAR

  • LONGVARCHAR

  • VARCHAR

Numeric Data

Learn about the supported numeric data types.

Oracle Analytics Server supports the following numeric data types:

  • BIGINT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

  • TINYINT

Date and Time Data

Oracle Analytics Server supports these data and time data types.
  • DATE

  • TIME

  • TIMESTAMP

Binary Data

Oracle Analytics Server supports numerous binary data types.

The supported binary data types are:

  • BIT

  • BINARY

  • LONGVARBINARY

  • VARBINARY