Re: SQL*Plus question

From: Mungo Henning <mungoh_at_itacs.strath.ac.uk>
Date: Thu, 13 May 1999 14:14:30 +0100
Message-ID: <373AD036.65FF5914@itacs.strath.ac.uk>

Jimmy wrote:

> Hello all,
>
> I have the following sql file running in SQL*Plus:
>
> spool a.txt
> select columnA || ',', columnB || ',', columnC || ',', columnD from
> AAA;
>

Change the select to:

columnA || ',' || columnB || ',' || columnC || ',' || columnD

thereby this query has only ONE column which is a composite of the four table-columns interspersed with commas.

HTH Mungo

--
Mungo Henning - it's a daft name but it goes with the face... mungoh@itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/ (since everyone else does it) I speak for me, not my employer. Received on Thu May 13 1999 - 08:14:30 CDT