SQL> set heading off
SQL> set echo off
SQL> set feedback off
SQL> set verify off
SQL> spool d:\test\result.csv
SQL> select hiredate,ename from emp;

17-DEC-80 SMITH
20-FEB-81 ALLEN
22-FEB-81 WARD
02-APR-81 JONES
28-SEP-81 MARTIN
01-MAY-81 BLAKE
09-JUN-81 CLARK
19-APR-87 SCOTT
17-NOV-81 KING
08-SEP-81 TURNER
23-MAY-87 ADAMS
03-DEC-81 JAMES
03-DEC-81 FORD

23-JAN-82 MILLER
SQL> spool off
SQL> set heading on
SQL> set echo on
SQL> set verify on

E:\>type d:\test\result.csv
SQL> select hiredate,ename from emp;

17-DEC-80 SMITH

20-FEB-81 ALLEN

22-FEB-81 WARD

02-APR-81 JONES

28-SEP-81 MARTIN

01-MAY-81 BLAKE

09-JUN-81 CLARK

19-APR-87 SCOTT

17-NOV-81 KING

08-SEP-81 TURNER

23-MAY-87 ADAMS

03-DEC-81 JAMES

03-DEC-81 FORD


23-JAN-82 MILLER

SQL> spool off

E:\>