What is a Cursor.
When a query is executed in oracle, a result set is produced and stored in the memory. Oracle allows the programmer to access this result set in the memory through cursors.
Why use a cursor?
Many times, when a query returns more than one row as a result, we might want to go through [...]
