17.10. Cursor declaration operator over a dynamically prepared select statement

  <dynamic declare cursor> :: =
    DECLARE <cursor name> [INSENSITIVE] [SCROLL]
    CURSOR FOR <statement name> 

Comment:

As defined in the new standard, for all DECLARE CURSOR operators, cursors are actually created at the start of a transaction and destroyed when it is completed. Note that in this statement, the <cursor name> and <statement name> are directly defined identifiers.