UNIX for Dummies Questions & Answers

Hi,

I think you are suppose to use TAB delimeter between fields of the database columns while spooling to a csv or xls file , it should work some thing like this


CHR(9) --is a TAB delimeter

sqlplus -s username/password <<END
set feedback off ;
spool filename.csv;
select emp_no||CHR(9)||ename||CHR(9)||sal from emp;
spool off;
exit;
END


##Sending mail attachment


uuencode filename.csv filename.csv |mailx -m -s "SEnding attachs " abc@email.com
I hope this will work.