A filter conjunction, disjunction and negation condition in SQL/JSON Path Expressions

A filter condition applies a predicate (Boolean function) to its arguments and is one of the following, where each of cond, cond1, and cond2 stands for a filter condition.

( cond ): Parentheses are used for grouping, separating filter condition cond as a unit from other filter conditions that may precede or follow it.

cond1 && cond2: The conjunction (and) of cond1 and cond2, requiring that both be satisfied.

cond1 || cond2: The inclusive disjunction (or) of cond1 and cond2, requiring that cond1, cond2, or both, be satisfied.

! ( cond ): The negation of cond, meaning that cond must not be satisfied.

Видео A filter conjunction, disjunction and negation condition in SQL/JSON Path Expressions канала OraPython