Oracle to Excel via Sqlplus
Try this on scott schema SET TERMOUT OFF SET FEEDBACK OFF SPOOL current_employees.xls SELECT ename||' '||ename AS "Employee Name", sal, hiredate, NVL(TO_CHAR(comm),'No Commission') AS "Commission", job FROM emp; OR Select * from emp; SPOOL OFF EXIT;