check_condition
|
|
---|---|
check_condition
|
::= check_item | check_item { AND | OR } check_item
|
check_item
|
::= [NOT] { check_test | ( check_condition ) }
|
check_test
|
::= comparison_test | between_test |
like_test | null_test | list_test |
comparison_test
|
::= expression { = | <> | < | <= | > | >= }
{ expression | subquery } |
between_test
|
::= column_identifier [NOT] BETWEEN
expression AND expression |
like Jest
|
::= column_identifier [NOT] LIKE value
[ESCAPE value ] |
null_test
|
::= column_identifier IS [NOT] NULL
|
\ist_test
|
::= expression [NOT] IN ( { value [, value ]...} )
|