Other Functions
| No. | Oracle Database | GaussDB |
|---|---|---|
| 1 | Supported. | |
| 2 | 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. |
| No. | Oracle Database | 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. | The KEEP syntax used in GaussDB is compatible with Oracle Database. |
| 9 | GROUPING | Supported. | - |
| 10 | LAST | Supported. | The KEEP syntax used in GaussDB is compatible with Oracle Database. |
| 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. | - |
| No. | Oracle Database | GaussDB | Difference |
|---|---|---|---|
| 1 | FIRST_VALUE | Supported. | - |
| 2 | LAG | Supported. | - |
| 3 | LAST_VALUE | Supported. | - |
| 4 | LEAD | Supported. | - |
| 5 | NTH_VALUE | Supported, with differences. |
|
| 6 | NTILE | Supported. | - |
| 7 | ROW_NUMBER | Supported. | - |
| 8 | RATIO_TO_REPORT | Supported. | - |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
