Sql Conditions Jp

論理(ブール)演算子で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 ]
           )