6 Conditions

A condition specifies a combination of one or more expressions and logical (Boolean) operators and returns a value of TRUE, FALSE, or UNKNOWN.

This chapter contains the following sections:

• About SQL Conditions

• Comparison Conditions

• Floating-Point Conditions

• Logical Conditions

• Range Conditions

• Null Conditions

• Compound Conditions

• EQUALS_PATH

• EXISTS

• IN

• IS A SET

• IS ANY

• IS EMPTY

• IS OF type

• IS PRESENT

• LIKE

• MEMBER

• REGEXP_LIKE

• SUBMULTISET

• UNDER_PATH