Help Center/ GaussDB/ Service Overview/ Compatibility with Oracle/ Distributed Instances/ System Functions/ Other Functions
Updated on 2024-05-14 GMT+08:00
View PDF

Other Functions

No.

Oracle

GaussDB

1

Aggregate functions

Supported.

2

Analytic functions

Supported.

3

Object reference functions

Not supported.

4

Models functions

Not supported.

5

OLAP functions

Not supported.

6

Data cartridge functions

Not supported.

7

User-defined functions

Supported.
Table 1 Aggregate functions

No.

Oracle

GaussDB

Difference

1

AVG

Supported.

-

2

CORR

Supported.

-

3

COUNT

Supported.

-

4

COVAR_POP

Supported.

-

5

COVAR_SAMP

Supported.

-

6

CUME_DIST

Supported.

-

7

DENSE_RANK

Supported.

-

8

FIRST

Supported.

-

9

GROUPING

Supported.

-

10

LAST

Supported.

-

11

LISTAGG

Supported.

-

12

MAX

Supported.

-

13

MEDIAN

Supported.

-

14

MIN

Supported.

-

15

PERCENT_RANK

Supported.

-

16

PERCENTILE_CONT

Supported.

-

17

RANK

Supported.

-

18

REGR_ (Linear Regression)

Supported.

-

19

STDDEV

Supported.

-

20

STDDEV_POP

Supported.

-

21

STDDEV_SAMP

Supported.

-

22

SUM

Supported.

-

23

VAR_POP

Supported.

-

24

VAR_SAMP

Supported.

-

25

VARIANCE

Supported.

-

26

WM_CONCAT

Supported, with differences.

The LISTAGG and STRING_AGG functions used in GaussDB are compatible with Oracle.
Table 2 Analytic functions

No.

Oracle

GaussDB

1

FIRST_VALUE

Supported.

2

LAG

Supported.

3

LAST_VALUE

Supported.

4

LEAD

Supported.

5

NTH_VALUE

Supported.

6

NTILE

Supported.

7

ROW_NUMBER

Supported.

8

RATIO_TO_REPORT

Supported.
Parent topic: System Functions