Data types supported in Oracle mode

OceanBase Database supports many data types in Oracle mode, as provided in the following list.

• Character data types

  • VARCHAR2

  • NVARCHAR2

  • CHAR

  • NCHAR

• Numeric data types

  • NUMBER

  • NUMBER_FLOAT

  • BINARY_FLOAT

  • BINARY_DOUBLE

• Complex data types

  • REF CURSOR

  • Struct

  • Array

  • RAW

  • ROWID

  • SDO_GEOMETRY

• Date and time data types

  • DATE

  • TIMESTAMP

  • TIMESTAMP WITH TIME ZONE

  • TIMESTAMP WITH LOCAL TIME ZONE

  • INTERVAL

  • INTERVALDS

  • INTERVALYM