Re: Selecting columnnames from other table

From: AWILSON <awilson_at_rci.rogers.com>
Date: 1996/12/10
Message-ID: <32ADFD81.307B_at_rci.rogers.com>#1/1

Joel Garry wrote:
>
> In article <586ag1$qrk_at_charm.il.ft.hse.nl> roger_at_il.ft.hse.nl (Roger Palmen) writes:
> >I want to select a number of columns from a database. (well, isn't that what
> >databases are about?) The columnnames which I want to retrieve are specified
> >in another table.
> >
> >
> >Anybody an idea?
> >

Try this sort of thing...

set pages 1000
set head off
set newpage 0
etc. etc.

select 'select '||col1||
       ','||col2||
       ','||col3||...etc

 from table
 where <where_condition>

spool sequel.sql
prompt set linesize 100
prompt set pagesize 60
/
spool off

start sequel        

---

The above reflect my personal views and in no way are connected with whomsoever I may be working for at this particular point in time.  

Alan Wilson                              Help fight continental drift.
======================================================================

Received on Tue Dec 10 1996 - 00:00:00 CET