Hi
The requirement is as follows:
Have a table (l_valid) that has 5 columns, of which 4 columns hold the name of related tables and 1 column has a key.
Now, I need to access these 4 tables using the key in a cursor. (this I have done).
Furthermore, after getting the names of 4 tables using the key, I need to iterate through the columns of each of these 4 tables in a cursor. How do I do this?
I done the following till now...
Code:
CURSOR c1 IS
SELECT hrank a, dbv b, dgv c, bbv d, fbv e, abv f, rbv g
from l_valid
where dbv is not null or
fbv is not null or
dgv is not null or
bbv is not null or
abv is not null or
rbv is not null;
CURSOR c2(p_b tab.tname%type) IS
SELECT tname h
FROM tab
WHERE tname = p_b;
Thanks for your input.