Hi,

How can I make the "FROM" clause variable using a cursor ??


Cursor c_one is
select tables
from all_tables
where ..... ;

r_c_one c_one%rowtype;

Cursor c_two is
select count(*)
from r_c_one.tables;

r_c_two c_two%rowtype;


Or... do I have to use dynamic SQL for this??

Please give me some examples on dynamic SQL ( its been ages ago I last used it ).

mvg GKramer