ans: Ref cursor is used for dynamic where clause and it is used for fast processing

by

Narendra kumar and Friend

shriram Group COmp(Madras) New Delhi

Normally in cursors query is defined at the time the cursor is created.

but in some cases the query we need to use for a cursor is unknown until run-time. Oracle uses ref-cursors and cursor variables to satisfy this requirement.

The scope of cursor is limited to a block/ programme. here block/ programme means upto a end of procedure/function and only one fixed query can be attached to that cursor.

where as the scope of ref cursor is global. Generally ref cursor is used with package so diffrent internal procedure/function of that package can use this ref cursor with diffrent query. so one cursor can have multiple query.