Syntax documentationrecursive_declare_cursor_statement Locate this document in the navigation structure

Syntax Syntax

  1. <recursive_declare_cursor_statement> ::=
      DECLARE <result_table_name> CURSOR FOR
        WITH RECURSIVE <reference_name> (<alias_name>,...)
        AS (<initial_select> UNION ALL <recursive_select>)
        <final_select>
End of the code.