Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-INSERT INTO--+-table-name-+--+-----------------------+------->
                '-view-name--'  |    .-,-----------.    |
                                |    V             |    |
                                '-(----column-name-+--)-'
 
>--+-------------------------+---------------------------------->
   +-OVERRIDING SYSTEM VALUE-+
   '-OVERRIDING USER VALUE---'
 
             .-,----------------------------.
             V                              |
>--+-VALUES----+-+-expression-+-----------+-+--+------------------+-+-><
   |           | +-DEFAULT----+           |    '-isolation-clause-' |
   |           | '-NULL-------'           |                         |
   |           |    .-,--------------.    |                         |
   |           |    V                |    |                         |
   |           '-(----+-expression-+-+--)-'                         |
   |                  +-DEFAULT----+                                |
   |                  '-NULL-------'                                |
   +-insert-multiple-rows--+------------------+---------------------+
   |                       '-isolation-clause-'                     |
   '-select-statement-----------------------------------------------'
 
insert-multiple-rows:
 
|--+-integer--+--ROWS--VALUES--(--host-structure-array--)-------|
   '-variable-'
 
isolation-clause:
 
|--WITH--+-NC-+-------------------------------------------------|
         +-UR-+
         +-CS-+
         +-RS-+
         '-RR-'