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]