All Products
Search
Document Center

Built-in functions

Last Updated: Sep 29, 2021

This topic describes the compatibility of OceanBase Database in Oracle mode with the native Oracle Database in terms of built-in functions.

Oracle Database supports 117 built-in functions, while OceanBase Database supports 103. For more information about the supported functions, see Functions.

Data functions

SN

Oracle Database

OceanBase Database

1

ABS

Supported

2

ACOS

Supported

3

ASIN

Supported

4

ATAN

Supported

5

ATAN2

Supported

6

BITAND

Supported

7

CEIL

Supported

8

COS

Supported

9

COSH

Supported

10

EXP

Supported

11

FLOOR

Supported

12

LN

Supported

13

LOG

Supported

14

MOD

Supported

15

NANVL

Supported

16

POWER

Supported

17

REMAINDER

Supported

18

ROUND (number)

Supported

19

SIGN

Supported

20

SIN

Supported

21

SINH

Supported

22

SQRT

Supported

23

TAN

Supported

24

TANH

Supported

25

TRUNC (number)

Supported

26

WIDTH_BUCKET

Supported

String functions

SN

Oracle Database

OceanBase Database

1

CHR

Supported

2

CONCAT

Supported

3

INITCAP

Supported

4

LOWER

Supported

5

LPAD

Supported

6

LTRIM

Supported

10

REGEXP_REPLACE

Supported

11

REGEXP_SUBSTR

Supported

12

REPLACE

Supported

13

RPAD

Supported

14

RTRIM

Supported

16

SUBSTR

Supported

17

TRANSLATE

Supported

18

TRIM

Supported

19

UPPER

Supported

20

ASCII

Supported

21

INSTR

Supported

22

LENGTH

Supported

23

REGEXP_COUNT

Supported

24

REGEXP_INSTR

Supported

Date functions

SN

Oracle Database

OceanBase Database

1

ADD_MONTHS

Supported

2

CURRENT_DATE

Supported

3

CURRENT_TIMESTAMP

Supported

4

DBTIMEZONE

Supported

5

EXTRACT (datetime)

Supported

6

FROM_TZ

Supported

7

LAST_DAY

Supported

8

LOCALTIMESTAMP

Supported

9

MONTHS_BETWEEN

Supported

10

NUMTODSINTERVAL

Supported

Type conversion functions

SN

Oracle Database

OceanBase Database

1

CAST

Supported

2

HEXTORAW

Supported

3

RAWTOHEX

Supported

4

TO_CHAR (character)

Supported

5

TO_CHAR (datetime)

Supported

6

TO_CHAR (number)

Supported

7

TO_CLOB

Supported

8

TO_DATE

Supported

9

TO_MULTI_BYTE

Supported

10

TO_NCHAR (character)

Supported

NULL-related functions

SN

Oracle Database

OceanBase Database

1

COALESCE

Supported

2

LNNVL

Supported

3

NANVL

Supported

4

NULLIF

Supported

5

NVL

Supported

6

NVL2

Supported

Aggregate functions

SN

Oracle Database

OceanBase Database

1

AVG

Supported

2

CORR

Supported

4

COUNT

Supported

5

COVAR_POP

Supported

6

COVAR_SAMP

Supported

7

CUME_DIST

Supported

8

MAX

Supported

9

MIN

Supported

10

PERCENT_RANK

Supported

11

RANK

Supported

12

STDDEV

Supported

13

STDDEV_POP

Supported

14

STDDEV_SAMP

Supported

15

SUM

Supported