UPDATE -+-> <table-name> -+-+---------------------+-+ +-> <view-name> --+ +> <correlation-name> + | +-------------------------------------------------+ +-> SET -+> <column-name> = -+-> value-expr -+-+-+ | +-> NULL -------+ | | | +-> DEFAULT ----+ | | +--------------- , <------------------+ | +------------------------- <---------------------+ ++--------------------------------------------------------+-+ +-> WHERE -+-> predicate -+---------------------------+-++ | | +> optimize-clause ---------+ | | +-> CURRENT OF <cursor-name> ----------------+ | +------------------------- <--------------------------------+ ++----------------------+------------------------------------> +-> returning-clause --+ optimize-clause = --+---------------------------------------------------------------+---> +-> OPTIMIZE --+-+-> FOR -+-> FAST FIRST --------+----------+-+-+ | | +-> TOTAL TIME --------+ | | | | +-> SEQUENTIAL ACCESS -+ | | | +-> USING <outline-name> ------------------+ | | +-> WITH -+-> DEFAULT --+-> SELECTIVITY -+ | | | +-> SAMPLED --+ | | | | +-> AGGRESSIVE + | | | +-> AS <query-name> -----------------------+ | +---------------- <----------------------------+ returning-clause= --+------------------------------+-+-------------------------+-> +-> RETURNING +-> value-expr +-+ +-> INTO +> <parameter> +-+ +------ , <----+ +------ , <----+