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
|
Results 1 to 2 of 2
Thread: Export oracle table to text fileThreaded View
|
Click Here to Expand Forum to Full Width |