0

Is there way to export Oracle table into CSV file ? I do not want to do it through Java but directly using any SQL/PLSQL command.

My table has few columns of type int, date, varchar. Column count is low say 5. But row count can be large 50 thousand+.

EDIT

I could think of below solution

spool on;
spool c:/7Jun.txt;
select ID||','||DESCRIPTION||','||CATEGORY from kaushik where id<=10;
spool out;
spool off;

This creates a file like

select ID||','||DESCRIPTION||','||CATEGORY from NLC where id<=10 ID||','||DESCRIPTION||','||CATEGORY                                                  
1,das
2,2342
3,434
4,4erwerw       5,trtsds 
5 rows selected
Kaushik Lele
  • 6,439
  • 13
  • 50
  • 76

0 Answers0