Shell Programming and Scripting

SELECT Distinct 'Success' As CallStatus, 
to_char (( (decode(J.ACCT_SESSION_TIME, 5,6, 4,6, 3,6, 2,6, 1,6, J.ACCT_SESSION_TIME)))) As CallDuration,  
( INITCAP(O.CUSTOMER_NAME) ) As Customer,  ( (C.countryname) ) As CallingSiteCountry,  
( INITCAP(A.CITY) ) As CallingSite,  
( Decode(AA.hostindicator,'ims',G.COUNTRYNAME,CC.COUNTRYNAME) ) As CalledCountry,  
( (Decode(AA.hostindicator,'ims','2','1')||Decode(length(J.MOBILEPREFIX),null,'0','1') ) ) As CallTypeSort, 
To_Char ((J.POSTDIALDELAY)) As PostDialDelay, J.TIMESTAMP as CalledTime
FROM ACCOUNTSALTR A, VOFR_JOURNAL J, VOFR_COUNTRY C, VOFR_COUNTRY CC,
VOF000.VOFR_ACCOUNTSALTR AA, VOF001.ODSCUSTINFO O, VOF000.VOFR_DNIS D, VOF000.VOFR_GMSRATES G 
WHERE A.IPADDRESS = J.ORIG_IP AND AA.IPADDRESS = J.DEST_IP AND A.ACCOUNTNO = O.BILLING_ACCOUNT_NUMBER 
AND D.PHONEPREFIX = G.PHONEPREFIX (+)  AND D.CALLED_STATION_ID (+) = J.CALLED_STATION_ID 
AND J.ACCT_SESSION_TIME > 0

$ sqlplus user/pass
SQL*Plus:...
:
SQL> set markup html preformat on
SQL> set colsep ','
SQL> set linesize 32000 trims on
SQL> set pagesize 0
SQL> spool tmpfile.csv
SQL> start script.sql
:
SQL> spool off
SQL> exit
Disconnected from Oracle Database...

$ sed -e 's/ *,/,/g' tmpfile.csv > outfile.csv