Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-CREATE VIEW--+-----------+--VIEW--view-name------------------>
                '-RECURSIVE-'
 
>--+----------------------------------------------------------------+-->
   |    .-,----------------------------------------------------.    |
   |    V                                                      |    |
   '-(----column-name--+-------------------------------------+-+--)-'
                       |      .-COLUMN-.                     |
                       '-FOR--+--------+--system-column-name-'
 
>--AS--+-----------------------------------+--fullselect-------->
       |       .-,-----------------------. |
       |       V                         | |
       '-WITH----common-table-expression-+-'
 
>--+----------------------------------+------------------------->
   |       .-CASCADED-.               |
   '-WITH--+----------+--CHECK OPTION-'
           '-LOCAL----'
 
>--+---------------------+-------------------------------------><
   '-RCDFMT--format-name-'