INSERT INTO -+-> <table-name> ----+-+---------------------------+-+-+
+-> <view-name> -----+ +-> AS <correlation-name> --+ | |
+-> CURSOR <cursor-name> ---------------------------+ |
+-------------------------------------------------------------------+
+---> DEFAULT VALUES ------------------+->-+---------------------+-+->
+--------------------------------+---+ | +-> returning-clause -+ |
+---> ( -+> <column-name> +-> ) -+ | | |
+-------- , <----+ | | |
+---------------<--------------------+ | |
+-> value-clause ----------------------+ |
+-> select-expr -+--------------------+--->------------------------+
+-> optimize-clause -+
value-clause =
----> VALUES -> ( -++> <parameter> ----------++-> ) --->
|+> <qualified-parameter> +|
|+> value-expr -----------+|
|+> DEFAULT --------------+|
+------- , <---------------+
returning-clause =
-+----------------------------------------++-------------------+->
+-> RETURNING value-expr ----------------++> INTO <parameter> +
+-> PLACEMENT ONLY RETURNING -+-> DBKEY -+
+-> ROWID -+
value-expr =
---+--> numeric-value-expr -----+----->
+--> char-value-expr --------+
+--> date-time-value-expr ---+
+--> interval-value-expr ----+
+--> date-vms-value-expr ----+
+--> DBKEY ------------------+
+--> NULL -------------------+
+--> ROWID ------------------+
select-expr =
-+-+-> select-clause ------------+-+------+
| +-> ( select-expr ) -----------+ | |
| +-> TABLE table-ref ----------+ | |
+------ select-merge-clause <-------+ |
+------------------- <-------------------+
+-+--------------------+--+------------------+--+--------------------+->
+-> order-by-clause -+ +-> offset-clause -+ +-> limit-to-clause -+
optimize-clause =
--+---------------------------------------------------------------+--->
+-> OPTIMIZE --+-+-> FOR -+-> FAST FIRST --------+----------+-+-+
| | +-> TOTAL TIME --------+ | |
| | +-> SEQUENTIAL ACCESS -+ | |
| +-> USING <outline-name> ------------------+ |
| +-> WITH -+-> DEFAULT --+-> SELECTIVITY -+ |
| | +-> SAMPLED --+ | |
| | +-> AGGRESSIVE + | |
| +-> AS <query-name> -----------------------+ |
+---------------- <----------------------------+
select-merge-clause =
-+-> EXCEPT -+--------------+---+----+-------------------+-->
| +-> DISTINCT --+ | +-> CORRESPONDING --+
+-> INTERSECT -+-------------+-+ +-> NATURAL --------+
| +-> DISTINCT -+ |
+-> MINUS ---------------------+
+-> UNION --+-------------+----+
+-> ALL ------+
+-> DISTINCT -+