| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*PLUS buffer width and buffer length stored where ??
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: 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).
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 - 11:49:25 CST
 |
 |