SQL*PLUS buffer width and buffer length stored where ??

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Tue, 04 Nov 2003 08:34:25 -0800
Message-ID: <F001.005D58DE.20031104083425@fatcity.com>

All, I have the issue with setting a basic format in sql plus

In my login.sql I have set line size 1000

Say I have a have a table with 20 columns and I select * from table where rownum <=2

What happens is I can't scroll the data... (The horizontal scroll is locked)) Unless I go into

Options>environment>
Screen buffer width 900
Screen buffer length 899

This works in my environment however Id like to roll out a default login.sql to users or have the ability to set the sessions for them.

I've search online and there doesn't seem a way to set the buffer width from a config file, only through the gui. I'm sure someone here knows that, or has a "complete" login.sql file to have the ability to enable the horizontal scroll by default

Thanks
Bob
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 04 2003 - 10:34:25 CST