Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: output to .txt
Works Great. Thx.
In article <3720D3FD.2C78408F_at_sympatico.ca>,
Marc Mazerolle <informaze_at_sympatico.ca> wrote:
>
> --------------B7617617D560C5F427005ED2
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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
>
> --------------B7617617D560C5F427005ED2
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <HTML>
> Use SQL*Plus "spool" command with a SELECT statement like :
>
> <P><TT>set pagesize 0</TT>
> <BR><TT>set echo off</TT>
> <BR><TT>set feedback off</TT>
> <BR><TT>set trims on</TT>
> <BR><TT>spool x.csv</TT>
> <BR><TT>SELECT COL_A||','||COL_B||','||COL_C</TT>
> <BR><TT> from my_table;</TT>
> <BR><TT>spool off</TT>
>
> <P>Regards,
>
> <P>Marc Mazerolle
> <BR>InforMaze Technologies
>
> <P>kgorman5414_at_my-dejanews.com wrote:
> <BLOCKQUOTE TYPE=CITE>This may seem like a stupid question, but is there
> an easy way to output
> <BR>oracle table data to a .txt file (or csv or whatever)? Is there
> a simple
> <BR>tool like SQL*UNloader?
>
> <P>help someone...
>
> <P>-----------== Posted via Deja News, The Discussion Network ==----------
> <BR><A
HREF="http://www.dejanews.com/">http://www.dejanews.com/</A> &n
bsp;
> Search, Read, Discuss, or Start Your Own</BLOCKQUOTE>
> </HTML>
>
> --------------B7617617D560C5F427005ED2--
>
>
--
-Kenny
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 17:06:20 CDT