SQL*Plus question

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Thu, 13 May 1999 20:35:38 -0700
Message-ID: <373B9A0A.BBDEBDEA@comp.polyu.edu.hk>

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 Received on Thu May 13 1999 - 22:35:38 CDT