Syntax

Click to skip syntax diagram

Searched UPDATE:

Read syntax diagramSkip visual syntax diagram>>-UPDATE--+-table-name-+--+--------------------+--------------->
           '-view-name--'  '-correlation-clause-'
 
>--+-------------------------+--SET--assignment-clause---------->
   +-OVERRIDING SYSTEM VALUE-+
   '-OVERRIDING USER VALUE---'
 
>--+-------------------------+--+------------------+-----------><
   '-WHERE--search-condition-'  '-isolation-clause-'
 

Positioned UPDATE:

Read syntax diagramSkip visual syntax diagram>>-UPDATE--+-table-name-+--+--------------------+--------------->
           '-view-name--'  '-correlation-clause-'
 
>--+-------------------------+--SET--assignment-clause---------->
   +-OVERRIDING SYSTEM VALUE-+
   '-OVERRIDING USER VALUE---'
 
>--WHERE CURRENT OF--cursor-name-------------------------------><
 

Read syntax diagramSkip visual syntax diagramassignment-clause::
 
     .-,------------------------------------------------------------.
     V                                                              |
|--+---+-+-column-name-------+-- = --+-expression-+---------------+-+-+--|
   |   | '-(--column-name--)-'       +-NULL-------+               |   |
   |   |                             '-DEFAULT----'               |   |
   |   |    .-,-----------.               .-,--------------.      |   |
   |   |    V             |               V                |      |   |
   |   '-(----column-name-+--)-- = --(--+---+-expression-+-+-+--)-'   |
   |                                    |   +-NULL-------+   |        |
   |                                    |   '-DEFAULT----'   |        |
   |                                    '-row-fullselect-----'        |
   |                .-,--------------.                                |
   |                V                |                                |
   '-ROW-- = --(--+---+-expression-+-+-+--)---------------------------'
                  |   +-NULL-------+   |
                  |   '-DEFAULT----'   |
                  '-row-fullselect-----'
 

Read syntax diagramSkip visual syntax diagramisolation-clause:
 
|--WITH--+-NC-+-------------------------------------------------|
         +-UR-+
         +-CS-+
         +-RS-+
         '-RR-'