Formatting page width?

[emikoo]

Hi,

I have an sqlplus query which I run from a unix box: The moment I do not add too many columns to the query, the query results are formatedd the way I want:

Column1 Column2 etc.
2,0000 50% etc.

Now the moment I add "too many" columns, formatting changes to a format I do not want:

Column1 2,0000
Column2 50%
etc. etc.

Any ideas on how to prevent this?

Thnxs in advance,

EK

 

[bppbme]

Get the SQL*Plus User's Guide from

http://tahiti.oracle.com/pls/tahiti/tahiti.docindex

and read about Formatting Query Results (like setting linesize and formatting columns with the COLUMN command)