Re: Is it possible to save SQLplus settings ?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 01 Oct 2003 21:34:25 +1000
Message-Id: <3f7abc7f$0$13656$afc38c87@news.optusnet.com.au>

Franz wrote:

> Hi all,
> does anybody know if it's possible to save some settings of a SQLplus
> session (like "set linesize")
> maybe setting it as default ?
> Thanks a lot
> Franz

Check out ORACLE_HOME/sqlplus/admin (the slashes go the other way around on Windows, of course, but otherwise the directory is identical). There's a file in there called "glogin.sql". Make changes to that, such as pagesize and linesize, and every time you then log onto SQL*Plus, those settings will take effect.

You can over-ride the glogin.sql settings by creating a login.sql, too. If it's in the directory where you launch SQL*Plus from, then login.sql takes precedence over glogin.sql.

Regards
HJR Received on Wed Oct 01 2003 - 06:34:25 CDT