Data types supported in Oracle mode

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

• Character types

  • VARCHAR2

  • NVARCHAR2

  • CHAR

  • NCHAR

• Numeric types

  • NUMBER

  • NUMBER_FLOAT

  • BINARY_FLOAT

  • BINARY_DOUBLE

• Composite data types

  • Ref Cursor

  • Struct

  • Array

  • RAW

  • RowId

• Date and time data types

  • DATE

  • TIMESTAMP

  • TIMESTAMP WITH TIME ZONE

  • TIMESTAMP WITH LOCAL TIME ZONE

  • Interval

  • INTERVALDS

  • INTERVALYM