sqlplus format

[DeltaFun]

Hi,
I have a question, how can I avoid word wrap on the output of sqlplus?
When I do sqlplus from oracle client on windows(9.2.0), if I set linesize 1000, it gives me the output(13 columns) without wrap. But if I do sqlplus from unix, or telnet from windows to unix, I get the wrapped output. Thanks for help.

D.F.

[slimdave]

the wrap is caused by the terminal -- if you spooled to a file you would not get wrapped output

[stecal]

set wrap [on | off]

[DeltaFun]

Thanks for help.
I spool the output to a file, but I still get the wrap.
I want all columns show up on one line like

col1 col2 col3 col4 col5 col6 col7 ...

I tried with client on windows even without spooling to a file. It works. But not on Unix. The program has to be run from unix.

[DeltaFun]

SQL> set linesize 1000
SQL> set wrap off
SQL> set heading off
SQL> spool foo.txt
SQL> select * from leadsin where rownum < 4;

6309069623 MALISKA BRUCE 973 WELLINGTON CIR AURORA IL 60506 0 0
6309069769 WILLIAMS CLIFFORD 130 TEALWOOD RD MONTGOMERY IL 60538 0 0
6309069982 CONNELLY JOHN 130 S HANKES RD AURORA IL 60506 0 0

Still not working......

[DeltaFun]

Sorry, when I post it, it seems to be working..... But when I look at the file, it still wrapped. Does that mean it is working? because I have no way of testing it.

[slimdave]

SQL> set linesize 1000
SQL> set wrap off
SQL> set heading off
SQL> spool foo.txt
SQL> select * from leadsin where rownum < 4;

6309069623 MALISKA                   BRUCE                     973 WELLINGTON CIR             AURORA               IL 60506                        0            0
6309069769 WILLIAMS                  CLIFFORD                  130 TEALWOOD RD                MONTGOMERY           IL 60538                        0            0
6309069982 CONNELLY                  JOHN                      130 S HANKES RD                AURORA               IL 60506                        0            0

Still not working......

It looks from your result like it is. Am i misinterpreting?

[slimdave]

By the way, i notice that you're posting real people's names here. That's a pretty dumb thing to do. Are you doing telemarketing lists?

[chrisrlong]

Do you have line-wrap on in the editor with which you are examining the file?

[DeltaFun]

I ftp to NT, and use notepad to open it and uncheck the word wrap, it worked. Thanks all for help.

DF