Conditions
GaussDB is compatible with most conditions of Oracle.
| 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 |
|
| 10 | Compound conditions | Supported | - |
| 11 | BETWEEN condition | Supported | - |
| 12 | EXISTS condition | Supported | - |
| 13 | IN condition | Supported | - |
| 14 | IS OF type condition | Not supported | - |
What is your overall rating for this page?
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot