Try to write your query into multiple lines:
select col1 || ';' || col2 || ';' || ..... colK
|| ';' || col(K+1) || ';' || ..... || ';' || colN
from mytable ;
HTH.
Guang
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?
>