Re: Oracle export table to ascii

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1064388157.228550_at_news.thyssen.com>...
> "R.A. Joemman" <raoul.joemman_at_wanadoo.nl> wrote...
> > Hi,
> >
> > I try to export a table from sqlplus to a ascii file like this:
> >
> >
> > select col1 || ';' || col2 || ';' || ..... || ';' || colN
> > from mytable ;
> >
 (snip)
> >
> > How do I export those wide tables?
> >
> > Best regards
> > Raoul
>
> Hi Raoul,
>
> another solution that might work for you:
> use the sql*plus command 'SET COLSEP'.
>
> hth,
> Guido

Thank you for this solution, it works for me. Raoul Received on Thu Sep 25 2003 - 14:21:09 CEST