Cursor Variables:

All of the explicit cursor instances we have seen so far are examples of static cursors. The cursor is related with one SQL statement and this statement is determined when the compilation of PL/SQL takes place.

A cursor variable, instead, can be related with various statements at run time. A Cursor variable is analogous to PL/SQL variables that can contain different values at run time. The Static cursors are analogous to PL/SQL constants, because they can only be relatd with one run-time query.

In sequence to use a cursor variable, that should first be declared. Storage intended for it must then be allocated at run time, because a cursor variable is a REF type.  That means, it is a reference type to a cursor. From this point opening a fetching of records and closing are same to those of Static Cursors.