Export Data Oracle to CSV

Follow below steps to create a CSV file from a employee table:

SQL> set colsep ";"

SQL> set heading off

SQL> set line 1000

SQL> spool employee.csv

SQL> select * from employee

      7782;CLARK     ;MANAGER  ;        10

      7839;KING      ;PRESIDENT;        11

      7934;MILLER    ;CLERK    ;        15

SQL>spool off