All Products
Search
Document Center

SQL data types

Last Updated: Aug 19, 2021

This topic describes the compatibility of OceanBase Database in Oracle mode with the native Oracle Database in terms of SQL data types.

Oracle Database supports 24 data types, while OceanBase Database supports 18. The following table lists the data types.

SN

Oracle Database

OceanBase Database

1

VARCHAR2(size)

Supported

2

NVARCHAR2(size)

Supported

3

NUMBER [ (p [, s]) ]

Supported

4

FLOAT [(p)]

Supported

5

LONG (deprecated type in Oracle Database)

Not supported

6

DATE

Supported

7

BINARY_FLOAT

Supported

8

BINARY_DOUBLE

Supported

9

TIMESTAMP [(fractional_seconds_precision)]

Supported

10

TIMESTAMP [(fractional_seconds_precision)] WITH TIME ZONE

Supported

11

TIMESTAMP [(fractional_seconds_precision)] WITH LOCAL TIME ZONE

Supported

12

INTERVAL YEAR [(year_precision)] TO MONTH

Supported

13

INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds_precision)]

Supported

14

RAW(size)

Supported

15

LONG RAW (deprecated type in Oracle Database)

Not supported

16

ROWID

Supported

17

UROWID [(size)]

Supported

18

CHAR (size)

Supported

19

NCHAR[(size)]

Supported

20

CLOB

Supported

21

NCLOB

Not supported

22

BLOB

Supported

23

BFILE

Not supported