Export oracle table to text file

I want to export some tables from Oracle Database to delimited Text file.

I try with SQL*Loader ... I didn't know how to use it for this issue.

Spool it in SQL*Plus:

Say the table is called EMP and has three columns: id, name, start_date.

In SQL*Plus type:

Code:

---

spool c:\temp\emp.lis
select id||';'||name||';'||to_char(start_date,'dd.mm.yyyy') from EMP;
spool off

---

The text file is in c:\temp.