Oracle® Database SQL Quick Reference 10g Release 2 (10.2) Part Number B14195-02 |
|
|
View PDF |
This chapter presents the syntax for combining one or more expressions and logical (Boolean) operators to specify a condition.
This chapter includes the following section:
A condition specifies a combination of one or more expressions and logical (Boolean) operators and returns a value of TRUE
, FALSE
, or unknown.
Conditions have several forms. The sections that follow show the syntax for each form of condition. Refer to Chapter 5, "Subclauses" for the syntax of the subclauses.
{ (condition) | NOT condition | condition { AND | OR } condition }
EQUALS_PATH (column, path_string [, correlation_integer ])
EXISTS (subquery)
expr IS [ NOT ] { NAN | INFINITE }
{ expr { = | != | ^= | <> | > | < | >= | <= } { ANY | SOME | ALL } ({ expression_list | subquery }) | expr [, expr ]... { = | != | ^= | <> } { ANY | SOME | ALL } ({ expression_list [, expression_list ]... | subquery } ) }
where !=
, ^=
, and <>
test for inequality
{ expr [ NOT ] IN ({ expression_list | subquery }) | ( expr [, expr ]... [ NOT ] IN ({ expression_list [, expression_list ]... | subquery } ) ) }
nested_table IS [ NOT ] A SET
[ dimension_column IS ] ANY
nested_table IS [ NOT ] EMPTY
expr IS [ NOT ] OF [ TYPE ] ([ ONLY ] [ schema. ] type [, [ ONLY ] [ schema. ] type ]... )
cell_reference IS PRESENT
char1 [ NOT ] ( LIKE | LIKEC | LIKE2 | LIKE4 ) char2 [ ESCAPE esc_char ]
{ NOT | AND | OR }
expr [ NOT ] MEMBER [ OF ] nested_table
expr IS [ NOT ] NULL
expr [ NOT ] BETWEEN expr AND expr
REGEXP_LIKE(source_char, pattern [, match_parameter ] )
{ expr { = | != | ^= | <> | > | < | >= | <= } expr | (expr [, expr ]...) { = | != | ^= | <> } (subquery) }
where !=
, ^=
, and <>
test for inequality
nested_table1 [ NOT ] SUBMULTISET [ OF ] nested_table2
UNDER_PATH (column [, levels ], path_string [, correlation_integer ] )