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