Change the Query of the cursor

Question

Dears I am working with PL-SQL and I need to define a cursor and then change the query of this cursor... How I can change the Query of the cursor

thx

Answer 1

You want to use an Oracle REF CURSOR.

This is a decent tutorial about REF CURSORs, but I'm sure google can provide you with more examples.