Help Center/ GaussDB/ Oracle Compatibility(Distributed)/ Pseudocolumns
Updated on 2024-12-06 GMT+08:00
View PDF
Share

Pseudocolumns

GaussDB is compatible with sequence and rownum pseudocolumns. Other pseudocolumns are not supported.

Hierarchical Query Pseudocolumns

Table 1 Hierarchical query pseudocolumns

No.

Oracle Database

GaussDB

1

connect_by_iscycle

Supported.

2

connect_by_isleaf

Supported.

3

LEVEL pseudocolumn

Supported.

Sequence Pseudocolumns

Table 2 Sequences

No.

Oracle Database

GaussDB

Difference

1

currval

Supported, with differences.

It is implemented as a function in GaussDB. The call mode is compatible with Oracle Database.

2

nextval

Supported, with differences.

It is implemented as a function in GaussDB. The call mode is compatible with Oracle Database.

ROWNUM Pseudocolumn

Table 3 rownum

No.

Oracle Database

GaussDB

Difference

1

rownum

Supported, with differences.

When Oracle Database uses rownum in the left, right, and full join conditions for filtering, the performance varies according to the conditions. The rownum condition may be ignored or partially ignored. However, GaussDB filters the results after left, right, and full join.

XMLDATA Pseudocolumn

Table 4 xmldata

No.

Oracle Database

GaussDB

1

xmldata

Not supported.