Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle table to flat file?
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:410fdc7d$0$18672$afc38c87_at_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
>
>
How so?
Received on Tue Aug 03 2004 - 16:15:11 CDT