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: Chris <cs123._no_spam__at_telstra.com>
Date: Tue, 03 Aug 2004 21:15:11 GMT
Message-ID: <zfTPc.31685$K53.7730@news-server.bigpond.net.au>

"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

Original text of this message

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