cursor_declaration ::= CURSOR cursor_name [(cursor_parameter_declaration [, cursor_parameter_declaration]...)] [ RETURN rowtype] IS select_statement; cursor_specification ::= CURSOR cursor_name [(cursor_parameter_declaration [, cursor_parameter_declaration]...)] RETURN rowtype; cursor_body ::= CURSOR cursor_name [(cursor_parameter_declaration [, cursor_parameter_declaration]...)] RETURN rowtype IS select_statement; RETURN rowtype IS select_statement; cursor_parameter_declaration ::= parameter_name [ IN] datatype [{:= | DEFAULT } expression]