Close Cursor « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. Close Cursor
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