In Oracle RefCursor is a cursor where we can change the 
select statement dynamically.

First a Refcursor Variable should be declared in 
Declaration Part

Refcursor Variable is like a normal variable, I.e. we can 
change the value of variable at any time..,similarly now 
Refcursor Variable can be changed with any sql query...