table name in cursor statement from another table row

[ggnanaraj]

Hi

Is it possible to DECLARE a cursor where the FROM clause should have a table name from another table row?

Thanks.

[gandolf989]

Like this?

SELECT * FROM mytable
WHERE c1 IN (SELECT c1 FROM myothertable);

or like this?

SELECT * FROM mytable
WHERE c1 = (SELECT c1 FROM myothertable WHERE c2 = 'AAA');

Please give a code example to describe what you are looking for.

[ggnanaraj]

Originally posted by gandolf989

Please give a code example to describe what you are looking for.

Hi

Thanks for your reply.

However, what I'm looking for is the following:

Table A consists of 201 rows, each row consisting of "table names". Of course, table A has a key with which I can refer to each row.

The requirement is to query the columns of "table names" rows of table A using the key, i.e.,

Table A:
col 1 col 1
----- -----
1 table b
2 table c
3 table d
.
.
.

cursor c1 is
select col1 from tablea;

cursor c2 is select col2oftableb, col3oftableb
from tableb; (this tableb in the from clause will/need be dynamic, depending on what is in table A.)

Is this possible ? Or should we go for hard coding in many programs and using some CASE structure to call each program depending on the key value passed?

Awaiting your response.