Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus question
This will work but so will the judicious use of the RTRIM funciton.
J
Mungo Henning wrote:
> 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:35:10 CDT