-
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.
Still learning
-
the wrap is caused by the terminal -- if you spooled to a file you would not get wrapped output
-
-
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.
Still learning
-
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......
Still learning
-
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.
Still learning
-
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
Still learning
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|