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