SQL*Plus question
From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Thu, 13 May 1999 20:35:38 -0700
Message-ID: <373B9A0A.BBDEBDEA_at_comp.polyu.edu.hk>
[Quoted] Hello all,
Date: Thu, 13 May 1999 20:35:38 -0700
Message-ID: <373B9A0A.BBDEBDEA_at_comp.polyu.edu.hk>
[Quoted] Hello all,
[Quoted] I have the following sql file running in SQL*Plus:
spool a.txt
[Quoted] [Quoted] 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, , TestingTesting...
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
Received on Fri May 14 1999 - 05:35:38 CEST