Expressions

An expression specifies a value.

Authorization: The use of some of the expressions, such as a scalar-fullselect, sequence-reference, function-invocation, or cast-specification may require having the appropriate authorization. For these expressions, the privileges held by the authorization ID of the statement must include the following authorization:
  • global variable. For information about authorization considerations, see Global variables.
  • scalar-fullselect. For information about authorization considerations, see Queries.
  • sequence-reference. The authorization to reference the sequence. For information about authorization considerations, see Notes.
  • function-invocation. The authorization to execute a user-defined function. For information about authorization considerations, see Function invocation.
  • array-element-specification. The authorization to reference an array type. For information about authorization considerations, see GRANT (type privileges).
  • cast-specification. The authorization to reference a user-defined type. For information about authorization considerations, see CAST specification.
Read syntax diagramSkip visual syntax diagramoperator +  - function-invocation(expression)constantcolumn-namevariablespecial-registerscalar-fullselectlabeled-durationarray-constructorarray-element-specificationcase-expressioncast-specificationOLAP-specificationrow-change-expressionsequence-referenceXMLCAST-specification

operator:

Read syntax diagramSkip visual syntax diagramCONCAT ∥  /  *  **  +  -