dynamic query cursor

[spicysudhi]

Hi,

How to create a cursor and process the data in loop; the cursor query is dynamic SQL. I mean the table names and couple of filtering parameters are passed at run time.

thanks for inputs.

regards,
Sudhi

 

[Dagon]

Not wishing to be rude, but have you tried looking in the Oracle manuals for this ? It's fairly standard stuff.