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.
Printable View
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:
The text file is in c:\temp.Code:spool c:\temp\emp.lis
select id||';'||name||';'||to_char(start_date,'dd.mm.yyyy') from EMP;
spool off