Total Pageviews

February 25, 2016

2/25/2016 10:16:00 AM
In order to generate a delimited file output, you need to concatenate columns using the desired delimiter i.e. comma:

Example:
select empno|| ‘,’||ename||’&’||mgr from X;

Other option is using:
SQL> set colsep ‘,’
SQL> spool c:\testexcel.csv
SQL> select * from emp;

Change some of the default SQL*Plus parameters, that will be garbage for Excel:
feedback=off
newpage=none
termout=off
header=off

If some columns are empty, be aware to include the delimiter, too:
nvl(to_char(col2),’,')