Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
式は、多くの場合、カラム参照の形式でデータを関数や演算子と組み合わせることによって形成されます。
expression: case-expression | constant | [correlation-name.]column-name | - expression | expression operator expression | ( expression ) | function-name ( expression, ... ) | if-expression | special value | input-parameter
case-expression: CASE expression WHEN expression THEN expression,... [ ELSE expression ] END
alternative form of case-expression: CASE WHEN search-condition THEN expression,... [ ELSE expression ] END
constant: integer | number | string | host-variable
special-value: CURRENT { DATE | TIME | TIMESTAMP } | NULL | SQLCODE | SQLSTATE
if-expression: IF condition THEN expression [ ELSE expression ] ENDIF
input-parameter: { ? | :name [ : indicator-name ] }
operator: { + | - | * | / | || | % }
式内の定数式内のカラム名IF 式CASE 式集合式式のサブクエリ入力パラメーター