Oracle export table to ascii

[R.A. Joemman]

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

[G M]

Try to write your query into multiple lines:

select col1 || ';' || col2 || ';' || ..... colK
|| ';' || col(K+1) || ';' || ..... || ';' || colN
from mytable ;

HTH.

Guang

ra***********@wanadoo.nl (R.A. Joemman) wrote in message news:<e4**************************@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

[Guido Konsolke]

"R.A. Joemman" <ra***********@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

[R.A. Joemman]

zl***@hotmail.com (G M) wrote in message news:<50**************************@posting.google. com>...

Try to write your query into multiple lines:

select col1 || ';' || col2 || ';' || ..... colK
|| ';' || col(K+1) || ';' || ..... || ';' || colN
from mytable ;

HTH.

Guang

ra***********@wanadoo.nl (R.A. Joemman) wrote in message news:<e4**************************@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

[R.A. Joemman]

"Guido Konsolke" <Gu************@triaton.com> wrote in message news:<10***************@news.thyssen.com>...

"R.A. Joemman" <ra***********@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