Re: Oracle export table to ascii
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Wed, 24 Sep 2003 09:29:01 +0200
Message-ID: <1064388157.228550_at_news.thyssen.com>
Date: Wed, 24 Sep 2003 09:29:01 +0200
Message-ID: <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
Received on Wed Sep 24 2003 - 09:29:01 CEST