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.