In Oracle, You can use the FETCH statement to retrieve rows from your cursor. After declaring and opening the cursor, the next step is to use the FETCH statement to fetch rows from your cursor.
To retrieve the rows from declared cursor in Oracle, use the following syntax:
Parameters:
cursor_name: The name of cursor.
variable_list: List of comma delimited variables to store the cursor result set.
Note:
In the above example, shows how to use the Fetch statement to retrieve rows from cursor.