login.sql not working? [message #439268] |
Fri, 15 January 2010 08:36 |
mike1976
Messages: 26 Registered: June 2005 Location: Happaugue, NY
|
Junior Member |
|
|
My problem is simple. I just got a new widescreen monitor and i want my sql*plus output to fill the whole page. I added the 'linesize 999' to my login.sql file but the line length only goes 100 characters across. It doesnt matter what kind of query or function i run. Still only 100 characters across. what else can i be missing?
My login file is attached
-
Attachment: login.sql
(Size: 1.38KB, Downloaded 1914 times)
|
|
|
Re: login.sql not working? [message #439270 is a reply to message #439268] |
Fri, 15 January 2010 08:41 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Do any of the commands in your login.sql work or is it just that one that's causing problems?
You do realise your attached file only has it set to 200?
|
|
|
Re: login.sql not working? [message #439271 is a reply to message #439270] |
Fri, 15 January 2010 08:46 |
mike1976
Messages: 26 Registered: June 2005 Location: Happaugue, NY
|
Junior Member |
|
|
no everything else in the login.sql seems to be working properly. I adjust settings almost daily and restart sql*plus and the changes always take effect.
Right now i counted the characters across and its exactly 100 characters displaying... 200 would fill the whole (wide) screen.
Thanks for your reply!!
|
|
|
|
|
|
|
|
Re: login.sql not working? [message #439297 is a reply to message #439268] |
Fri, 15 January 2010 09:36 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It might make it easier to see what's going on. It appears from you're example that lines of text are being truncated. That shouldn't happen even if lines is set too low - oracle should just multi-line it.
e.g:
SQL> select 'aaaaaaaaaaaaaaaaaaaa'||'bbbbbbbbbbbbbbbb'||'cccccccccccccccccc'||'ddddddddddddddd'||'eeeeeeeeeeeee' from dual;
'AAAAAAAAAAAAAAAAAAAA'||'BBBBBBBBBBBBBBBB'||'CCCCCCCCCCCCCCCCCC'||'DDDDDDDDDDDDDDD
----------------------------------------------------------------------------------
aaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbccccccccccccccccccdddddddddddddddeeeeeeeeeeeee
SQL> set lines 50;
SQL> /
'AAAAAAAAAAAAAAAAAAAA'||'BBBBBBBBBBBBBBBB'||'CCCCC
--------------------------------------------------
aaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbcccccccccccccc
ccccdddddddddddddddeeeeeeeeeeeee
SQL>
|
|
|
|
|
|
|
Re: login.sql not working? [message #439353 is a reply to message #439323] |
Fri, 15 January 2010 14:54 |
mike1976
Messages: 26 Registered: June 2005 Location: Happaugue, NY
|
Junior Member |
|
|
I'm sorry what expression do i need to give an alias?
Something in my log file?
Would this:
select a.text_value from nai_samples a
produce better output than:
select text_value from nai_samples???
I'm not sure i understand where the alias needs to be added.
Thank you,
Mike
|
|
|
|
|
|