Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram        .-,-------------------------------------------------------------------------.
        V                                                                           |
>>-SET----+-transition-variable-- = --+-expression-+------------------------------+-+-><
          |                           +-NULL-------+                              |
          |                           '-DEFAULT----'                              |
          |    .-,-------------------.               .-,--------------.           |
          |    V                     |               V                | (1)       |
          '-(----transition-variable-+--)-- = --(--+---+-expression-+-+------+--)-'
                                                   |   +-NULL-------+        |
                                                   |   '-DEFAULT----'        |
                                                   |                (2)      |
                                                   '-row-fullselect----------'
 
Notes:
  1. The number of expressions, NULLs, and DEFAULTs must match the number of transition-variables.
  2. The number of columns in the select list must match the number of transition-variables.