hi..

Refcursor is nothing but dynamic cursor... it means u can 
change the cursor definition at run time... unless like 
normal cursor where u define and declare once.

thanx..

refcusor is globAL DECLARATION FOR EVERY AT THE TIME OF
OPENING CURSOR WE PASS SELECT STATEMENT DYNAMICALLY

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...