Close Cursor « Cursor « Oracle PL / SQL

1.Below is a function that demonstrates how to use the CLOSE statement
2.Closing the Cursor Variable
3.Close a cursor after looping
4.Close a cursor and open it again with another query
5.After the cursor is opened, the book table is dropped prior to looping through the cursor.
6.Close cursor after while loop
7.Close cursor in excpetion handler