In Oracle, once you have finished using cursor, the next step is to close the declared cursor. You can use the CLOSE statement to close the cursor.
To close a declared cursor in Oracle, use the following syntax:
Parameters:
cursor_name: The name of cursor.
Note:
In the above example, shows how to use the Close statement to open cursor.