Re: SQL*Plus question

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_at_itacs.strath.ac.uk.http://www.itacs.strath.ac.uk/
(since everyone else does it) I speak for me, not my employer.