I am using sqlplus in shell script to connect to DB and spool .csv file.
code is:-
sqlplus -s user/pass@db <<EOF> /dev/null 2>&1
SET COLSEP ','
SET FEEDBACK OFF
SET TRIMSPOOL ON
SET UNDERLINE OFF
SET LINESIZE 10000
SET PAGESIZE 10000
spool customer.csv
select * from customer where cust_name='john';
spool off
EOF
output:-
i get my header trim for few Colum's like 1st, 2nd 4th and 7th.
expected output:-
You'd need to tell SQL*Plus how wide you want the columns to be. Assuming I've counted the length of each header correctly
column sys_creation_date format a17
column sys_update_date format a15
column dl_service format a10
column eff_date_time format a13
You may be happier switching, though, to SQLcl since that makes generating CSV files easier. Just
select /*csv*/ * from emp
or
set sqlformat csv
select * from emp
SQL*Plus, and you want to make sure that a column header prints out completely, you'd need to format the column. Yes, that's potentially 70 lines of formatting if your query has 70 columns. Which is why SQLcl is generally the better option unless you're wedded to older tools for some reason.
SQL*Plus.