Home » SQL & PL/SQL » SQL & PL/SQL » problem setting linesize in SQL Plus
problem setting linesize in SQL Plus [message #17260] Mon, 03 January 2005 08:30 Go to next message
Nina
Messages: 113
Registered: March 2000
Senior Member
Hi,
I am trying to set the linesize so that output does not wrap. When I set it to 200, output looks fine except that it is cut off to the right of the screen and I can't scroll across to see the rest of it. Can anyone help?
Btw, I am using Sql Plus 8.0.6.0.0
Nina
Re: problem setting linesize in SQL Plus [message #17261 is a reply to message #17260] Mon, 03 January 2005 09:09 Go to previous messageGo to next message
sverch
Messages: 582
Registered: December 2000
Senior Member

No way. Unfortunately. However, if you spoil your result you can view it. Or query in Toad.
Re: problem setting linesize in SQL Plus [message #17262 is a reply to message #17260] Mon, 03 January 2005 09:17 Go to previous messageGo to next message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
Horizontal scrolling depends on the terminal used. The Windows command-line version is pretty good. I'm not near Windows right now, but if you go through all the window settings there should be a couple for window size. I always change the colour and font etc as well.

Unfortunately the SQL*Plus DESCRIBE command automatically adjusts itself to fit the current LINESIZE, so you can have either horizontal scrolling or readable DESCRIBE output, but not both.
Re: problem setting linesize in SQL Plus [message #17263 is a reply to message #17261] Mon, 03 January 2005 09:19 Go to previous messageGo to next message
sverch
Messages: 582
Registered: December 2000
Senior Member
I meant SPOOL

:))))
Re: problem setting linesize in SQL Plus [message #17266 is a reply to message #17260] Mon, 03 January 2005 20:53 Go to previous message
Hassan
Messages: 19
Registered: November 2001
Junior Member
hi there;

use the following statements:

set linesize 20000
and then go the environment and set the array size to 5 default it is 15.
u will see the whole of ur record.
Regards.
hassan
Previous Topic: Error when Inner query calls Function - Please help, urgent
Next Topic: what are the SQL classifications
Goto Forum:
  


Current Time: Fri Jul 25 11:24:17 CDT 2025