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 -+