Interesting finding here ORCL9 SQL> Store set C:\oracle\ora92\dbs\login.sql Or if the file exists ORCL9 SQL> Store set C:\oracle\ora92\dbs\login.sql append
That generates a substantial config file, much more than a standard login I have to test if it actually keeps the buffer width and length. I don't see it in there, though..... Bob -----Original Message----- Sent: Tuesday, November 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L 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). -- 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).