Re: Oracle export table to ascii
Date: 23 Sep 2003 13:24:15 -0700
Message-ID: <50a5e6b6.0309231224.4b2bd627_at_posting.google.com>
Try to write your query into multiple lines:
select col1 || ';' || col2 || ';' || ..... colK
|| ';' || col(K+1) || ';' || ..... || ';' || colN from mytable ;
raoul.joemman_at_wanadoo.nl (R.A. Joemman) wrote in message news:<e4e5e80f.0309230313.56ad0e49_at_posting.google.com>...
> Hi,
>
> I try to export a table from sqlplus to a ascii file like this:
>
>
> select col1 || ';' || col2 || ';' || ..... || ';' || colN
> from mytable ;
>
> When the table is not so wide, the above query is not so large and the
> export is succesfull.
> But when the table is wide, the query becomes over 1024 characters and
> I get the following error
>
> ORA-00923: FROM keyword not found where expected
>
> How do I export those wide tables?
>
> Best regards
> Raoul
Received on Tue Sep 23 2003 - 22:24:15 CEST