Oracle Database Discussions

I need to set the colsep for the data that I am unloading. I am getting spaces. Thsi is what I am doing.

sqlplus -s $CONN << EOF
set colsep ,;

set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on;

spool $OUT_FILE;

select id, name from filing f

spool off;

set echo on newpage 0 space 0 pagesize 0 feed on ;

drop table filing;
EOF

I am getting space separated output in output file even though I have set colsep ","

Also the columns are being printed on new line. How can I get output like
1|2
1|2
3|4

instead of getting every column on new line

Message was edited by:
user628400