Sql Conditions Jp
Table of Contents
論理(ブール)演算子でTRUE、FALSEまたはUNKNOWNを計算する式
複合条件
{ (condition) | NOT condition | condition { AND | OR } condition }
EQUALS_PATH条件
EQUALS_PATH (column, path_string [, correlation_integer ])
EXISTS条件
EXISTS (subquery)
浮動小数点条件
expr IS [ NOT ] { NAN | INFINITE }
グループ比較条件
{ expr { = | != | ^= | <> | > | < | >= | <= } { ANY | SOME | ALL } ({ expression_list | subquery }) | expr [, expr ]... { = | != | ^= | <> } { ANY | SOME | ALL } ({ expression_list [, expression_list ]... | subquery } ) } !=、^=および<>は不等性テストを表します。
IN条件
{ expr [ NOT ] IN ({ expression_list | subquery }) | ( expr [, expr ]... [ NOT ] IN ({ expression_list [, expression_list ]... | subquery } ) ) }
IS A SET条件
nested_table IS [ NOT ] A SET
IS ANY条件
[ dimension_column IS ] ANY
IS EMPTY条件
nested_table IS [ NOT ] EMPTY
IS OF TYPE条件
expr IS [ NOT ] OF [ TYPE ] ([ ONLY ] [ schema. ] type [, [ ONLY ] [ schema. ] type ]... )
IS PRESENT条件
cell_reference IS PRESENT
LIKE条件
char1 [ NOT ] ( LIKE | LIKEC | LIKE2 | LIKE4 ) char2 [ ESCAPE esc_char ]
論理条件
{ NOT | AND | OR }
MEMBER条件
expr [ NOT ] MEMBER [ OF ] nested_table
NULL条件
expr IS [ NOT ] NULL
範囲条件
expr [ NOT ] BETWEEN expr AND expr
REGEXP_LIKE条件
REGEXP_LIKE(source_char, pattern [, match_parameter ] )
単純比較条件
{ expr { = | != | ^= | <> | > | < | >= | <= } expr | (expr [, expr ]...) { = | != | ^= | <> } (subquery) } !=、^=および<>は不等性テストを表します。
SUBMULTISET条件
nested_table1 [ NOT ] SUBMULTISET [ OF ] nested_table2
UNDER_PATH条件
UNDER_PATH (column [, levels ], path_string [, correlation_integer ] )