Jimmy wrote:
>
> Hello all,
>
> I have the following sql file running in SQL*Plus:
>
> spool a.txt
> select columnA || ',', columnB || ',', columnC || ',', columnD from
> AAA;
> spool off
>
> Results: (content of a.txt)
> columnA, columnB, columnC, columnD
> 11, ABC, 01-Jan-1998, Testing
> 1234, DEFG, 01-Jan-1999, Hello This is testing
>
> 134, A, , Testing
> Testing...
>
> However, I want to use SQL*PLUS to get the following results:
>
> Results: (content of a.txt)
> columnA,columnB,columnC,columnD
> 11,ABC,01-Jan-1998,Testing
> 1234,DEFG,01-Jan-1999,Hello This is testing
> 134,A,,Testing Testing
>
> i.e., no space between two column values. Is it possible to do that
> in running sql file in SQL*Plus?
>
> Thanks,
> Jimmy
Use a select ltrim(rtrim(columname,' '),' ') from AAA;
Eric
Received on Thu May 13 1999 - 14:01:13 CDT
