Hi DBA Gurus and developers,



I have a procedure that retrieves tablename(eg:-table1) from a table .

Based on that value(table name) I have to fetch the data from another
table (eg:-table1)

It retrieves more than one row, so I have to use a cursor. ALso I have
to update that table with a value.

So, should I use ref cursor? if yes, how to do that? then while
declaring cursor should I give for update clause?

Please help me

Thanks in advance

Regards,
Raj




Oracle LazyDBA home page