SQL & PL/SQL

Hi,

Please help me to remove white spaces in the below script:

set term off

set echo off

set underline off

set colsep ','

set linesize 100000

set pages 40000

SET LONG 50000;

set trimout on

set trimspool on

set feedback off

set heading off

set headsep off

spool test.csv;

select 'A', DEST_NAME,status, destination from v$archive_dest where status='VALID';

spool off

output it produces as:

'A',LOG_ARCHIVE_DEST_1

                                                                                               ,VALID    ,/tst/install/tst/data/archive

Real problem is : I created external table based on the above csv file. So, while reading this content, I'm getting an error. However, if i'm getting one line output then it is displaying properly.