Re: output to .txt

Use SQL*Plus "spool" command with a SELECT statement like :

set pagesize 0
set echo off
set feedback off
set trims on
spool x.csv
SELECT COL_A||','||COL_B||','||COL_C
  from my_table;
spool off

Regards,

Marc Mazerolle
InforMaze Technologies

kgorman5414_at_my-dejanews.com wrote:

> This may seem like a stupid question, but is there an easy way to output
> oracle table data to a .txt file (or csv or whatever)? Is there a simple
> tool like SQL*UNloader?
>
> help someone...
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 23 1999 - 15:07:57 CDT