Re: SQL*PLUS Screen Buffer

Ulf,

I currently use login.sql to set my default SQL*plus environment, but there are no settings to control the screen buffer. I currently set the page size and line size among others, but that only controls what is returned from Oracle, not what my SQL*Plus screen buffer displays.

Here is an extract from the SQL*Plus docs to clarify what I mean:

• Screen Buffer When you change the Screen Buffer option, SQL*Plus displays a warning dialog box to alert you that if you shorten the size of your screen buffer, some data may not be displayed on your screen. Click OK if you want to proceed.

The Screen Buffer dialog box consists of two text boxes: Buffer Width and Buffer Length.

Buffer Width

Sets the number of characters SQL*Plus displays on one line. If you enter a number smaller than the length of output data, SQL*Plus truncates the data to match the buffer width you specified. The default value of the Buffer Width parameter is 80 characters. You can specify from 80 to 1,000 characters on one line.

Buffer Length

Sets the number of lines SQL*Plus displays on the screen. If SQL*Plus displays more lines of data than you specify, the remaining lines of data will "wrap around" to the top of the screen buffer. The default value of the Buffer parameter is 100 lines. You can specify from 100 to 2,000 lines on

t6he screen. ********************

So in summary I can use the set commands to control what Oracle returns, but I want to control the default settings of what SQL*Plus has in the screen buffer. A buffer length of 2,000 will allow me to scroll back 2,000 lines of data in lieu of the default setting of 100 lines. Likewise after editing a file and returning to SQL*Plus, it only will display on the screen lines up to 80 characters in length (the default setting), truncating longer lines. Because I have a large screen I want the screen to display 132 characters not 80. I understand that the SQL*Plus set options do not control these settings and that is why they are separate menu items in the Opiton menu - but I would still like to increase the defaults so I don't have to change them for each session.

Regards,

Bob J

In article <6uauvr$sap_at_newstoo.ericsson.se>,   "Ulf Magnusson" <ulf.magnusson_at_briunix.kiedt.ericsson.se> wrote:
> If you have a login.sql file in your startup directory for sqlplus in
> Windows
> or home directory in unix sqlplus execute that file on startup.
>
> /Ulf
>
> rjager_at_tctyhfdc.telecom.com.au wrote in message
> <6u9u0v$fb1$1_at_nnrp1.dejanews.com>...
> >I get sick and tired of having to set my screen buffer width to 132 (ILO
> 80)
> >each time I enter SQL*Plus. Is there any way that I can set it as a
> default?
> >
> >Bob Jager
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 06:52:12 CEST