Sql output to .csv not in format
Hi Gurus,
when converting SQL output to .csv , I am getting scrambled output. I was trying since 2 days to fix it but some or other is missing in format.
Could someone help me in solving it.
I really appreciate your help.
Following is the sql query.
alter session set nls_date_format='DD_MON_YYYY HH24:MI:SS';
set lines 500 pages 0 veri off echo off feed off trimspool on termout off timing off
spool &1
select '"dateexpressed","email","readyforservicedate","adborid","segment",'||
'"title","firstname","lastname","contactnumber","secondarynumber","addrunit",'||
'"addrstreetnum","addrstreetname","addrstreettype","addrsuburb","addrstate",'||
'"addrpostcode","existingcustomer","businessname","hasaccountmanager",'||
when converting SQL output to .csv , I am getting scrambled output. I was trying since 2 days to fix it but some or other is missing in format.
Could someone help me in solving it.
I really appreciate your help.
Following is the sql query.
alter session set nls_date_format='DD_MON_YYYY HH24:MI:SS';
set lines 500 pages 0 veri off echo off feed off trimspool on termout off timing off
spool &1
select '"dateexpressed","email","readyforservicedate","adborid","segment",'||
'"title","firstname","lastname","contactnumber","secondarynumber","addrunit",'||
'"addrstreetnum","addrstreetname","addrstreettype","addrsuburb","addrstate",'||
'"addrpostcode","existingcustomer","businessname","hasaccountmanager",'||
0