SQL> SET UNDERLINE OFF
SQL> SET COLSEP ','
SQL> SET LINES 100 PAGES 100
SQL> SET FEEDBACK off
SQL> SET HEADING off
SQL> Spool e:emp.csv
SQL> select * from emp;

7369,SMITH ,CLERK , 7902,1980-12-17 00:00:00, 800, , 20
7499,ALLEN ,SALESMAN , 7698,1981-02-20 00:00:00, 1600, 300, 30
7521,WARD ,SALESMAN , 7698,1981-02-22 00:00:00, 1250, 500, 30
7566,JONES ,MANAGER , 7839,1981-04-02 00:00:00, 2975, , 20
7654,MARTIN ,SALESMAN , 7698,1981-09-28 00:00:00, 1250, 1400, 30
7698,BLAKE ,MANAGER , 7839,1981-05-01 00:00:00, 2850, , 30
7782,CLARK ,MANAGER , 7839,1981-06-09 00:00:00, 2450, , 10
7839,KING ,PRESIDENT, ,1981-11-17 00:00:00, 5000, , 10
7844,TURNER ,SALESMAN , 7698,1981-09-08 00:00:00, 1500, 0, 30
7900,JAMES ,CLERK , 7698,1981-12-03 00:00:00, 950, , 30
7902,FORD ,ANALYST , 7566,1981-12-03 00:00:00, 3000, , 20
7934,MILLER ,CLERK , 7782,1982-01-23 00:00:00, 1300, , 10
SQL> spool off;
SQL>