검색 조건

<search condition>

<boolean term> [ OR <boolean term> ]...

<boolean term>

<boolean factor> [ AND <boolean factor> ]...

<boolean factor>

[ NOT ] <boolean primary>

<boolean primary>

<predicate>

<predicate>

<exists predicate>
| <comparison predicate>
| <multi column predicate>
| <between predicate>
| <in predicate>
| <like predicate>
| <is null predicate>
| <set predicate>

<exists predicate>

EXISTS <expression>

<comparison operator>

<expression> <comparison operator> [ <quantifier> ] <expression>

<quantifier>

=
| < >
| <
| <=
| >
| >=

<multi column predicate>

ALL
| SOME
| ANY

<multi in predicate>

{<multi in predicate> | <multi comparison predicate>}

<between predicate>

(<expression comma list>)
[NOT] IN ( <query expression> )

<in predicate>

( <expression comma list> ) { = | < > }
( { <expression comma list> | <query expression> } )

<like predicate>

<expression> [NOT] LIKE <expression> [
ESCAPE <string literal> ]

<is null predicate>

<expression> IS [NOT] NULL

<set predicate>

<expression> <set operator> <expression>

<set opera>

SETEQ
| SETNEQ
| SUPERSET
| SUPERSETEQ
| SUBSET
| SUBSETEQ