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 |