Updated on 2026-05-16 GMT+08:00

Conditions

GaussDB is compatible with most conditions of Oracle.

Table 1 Conditions

No.

Oracle

GaussDB

Difference

1

Comparison conditions

Supported with differences

Differences exist when statements contain the ANY, SOME, and ALL operators. Oracle supports operations on the List object, but you need to convert the List object into array expressions before performing operations on GaussDB.

2

Floating-point conditions

Not supported

-

3

Logical conditions

Supported

-

4

Model conditions

Not supported

-

5

Multiset conditions

Not supported

-

6

Pattern-matching conditions

Supported

-

7

Null conditions

Supported

-

8

XML conditions

Not supported

-

9

SQL/JSON conditions

Partially supported with differences

  • GaussDB does not support the IS JSON or JSON_TEXTCONTAINS conditions.
  • The JSONB_EQ condition in GaussDB is the same as the JSON_EQUAL condition in Oracle. However, GaussDB does not support the ERROR clause.
  • The JSONB_EXISTS condition in GaussDB is the same as the JSON_EXISTS condition in Oracle. However, GaussDB does not support the ERROR, EMPTY, or PASSING clause.

10

Compound conditions

Supported

-

11

BETWEEN condition

Supported

-

12

EXISTS condition

Supported

-

13

IN condition

Supported

-

14

IS OF type condition

Not supported

-