A cursor is a pointer to context area i.e. Context area is controlled by the cursor. It is used to fetch and manipulate the data returned by the SQL statement.
Note: The set of rows the cursor holds is known as active set.
CURSOR cur_students IS SELECT rollNo, name, address FROM students;
See more at: Plsql cursor.