From: arielk@exlibris.co.il
Subject: Dynamic FROM clause using SQLPLUS
Date: 1997/11/11
Message-ID: <879263478.27667@dejanews.com>#1/1
X-Http-User-Agent: Mozilla/4.03 [en] (Win16; I)
X-Originating-IP-Addr: 192.114.71.228 ()
Organization: Deja News Posting Service
X-Authenticated-Sender: arielk@exlibris.co.il
X-Article-Creation-Date: Tue Nov 11 15:51:19 1997 GMT
Reply-To: arielk@exlibris.co.il
Newsgroups: comp.databases.oracle.misc



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