sqlplus format

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.

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

set wrap [on | off]

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.

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......

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.

Code:

---

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?

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?

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

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

DF

I just called Bruce Maliska.
He is really pissed off at you.

Have a nice day.
:rolleyes:

Yeah, his wife Debbie probably ain't too happy either.