Output width....

[spencer]

I need to change the column width from 80 to 2000 when I spool the
results of a query out to a file. I cannot figure out how to do this
in Oracle. Any help is appreciated...

Thanks...
Spencer

[Chris Chiancone]

"spencer" <shearer@channel1.com> wrote:
>
>I need to change the column width from 80 to 2000 when I spool the
>results of a query out to a file. I cannot figure out how to do this
>in Oracle. Any help is appreciated...
>
>Thanks...
>Spencer
Spencer,

Lets say your filed name is test, the way you format a column is:
col test format 2000

then spoon and print landscape

[kett]

"spencer" <shearer@channel1.com> wrote:
>
>I need to change the column width from 80 to 2000 when I spool the
>results of a query out to a file. I cannot figure out how to do this
>in Oracle. Any help is appreciated...
>
>Thanks...
>Spencer


click on options then environment,
choose linesize under options
and change value to the buffer size.

you will probably have to change the buffer size in order to get to 2000