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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
