Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus question

Re: SQL*Plus question

From: Jerry Metz <JMetz1_at_ix.netcom.com>
Date: Thu, 13 May 1999 08:35:10 -0500
Message-ID: <373AD50E.F152F108@ix.netcom.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US