Re: Oracle export table to ascii

zlmei_at_hotmail.com (G M) wrote in message news:<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 ;
>
> 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?
> >
> > Best regards
> > Raoul

Thank you, this works for me.
Raoul Received on Thu Sep 25 2003 - 14:20:10 CEST