DECLARE <cursor-name-parameter> ---------------+ +----------------------------------------------+ ++---+----------------+-> TABLE CURSOR -+----------------++ | +-> INSERT ONLY -+ +-> with-clause -+| | +-> READ ONLY ---+ | | +-> UPDATE ONLY -+ | | +------------------------------------------------------+ | +--> FOR ---> <statement-id-parameter> ------------+-------> +-+--------------++----------++-> LIST CURSOR FOR -+ | +-> READ ONLY -++> SCROLL -+| | | +-> INSERT ONLY ------------+ | | +--------------------------------------------------+ | +-> <statement-id-parameter> ------------------------+ with-clause = ---> WITH --> HOLD -+-------------------------------+-> +-> PRESERVE --+-> ON COMMIT ---+ +-> ON ROLLBACK -+ +-> ALL ---------+ +-> NONE --------+