Dynamic FROM clause using SQLPLUS

Hi there,

I have asked this question before about REPORTS 2.5, but now I need an answer concerning SQLPLUS :

How can I select data from a table, whose name appears as a field in the master table of a master/detail report.

i.e.
if Table1 includes :
TABLE_NAME CHAR(5)
DOC_NUM NUMBER(9) and tables MAIN_LIB and SECONDARY_LIB include : DOC_NUM NUMBER(9)
TITLE VARCHAR2(100) What SQLPLUS code would I use to retrieve the titles of all the documents in Table1 from their relevant tables ?

                      Sincerely,

                            Ariel Kirson
                            Ex Libris.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet