Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle table to flat file?

Re: oracle table to flat file?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 4 Aug 2004 04:42:45 +1000
Message-ID: <410fdc7d$0$18672$afc38c87@news.optusnet.com.au>

"Chris" <cs123._no_spam__at_telstra.com> wrote in message news:NLMPc.31041$K53.12513_at_news-server.bigpond.net.au...

> >
> > If you'd prefer a CSV, then something like:
> >
> > spool textfile.csv
> > select empno ||','||ename||','||sal from scot.emp;
> > spool off
> >
> > Regards
> > HJR
> >
> >
>
> or
>
> set colsep ','
> select * from emp;
>

Nice try, but the output's quite different, and there's a danger with colsep that you'll embedd trailing spaces into your data.

Regards
HJR Received on Tue Aug 03 2004 - 13:42:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US