Re: startup environment in sqlplus?
Date: Wed, 27 Jan 1999 09:55:36 GMT
Message-ID: <78mnql$jc5$1_at_nnrp1.dejanews.com>
In article <78l834$ciu$1_at_nnrp1.dejanews.com>,
ewong74_at_netscape.net wrote:
> Hi,
>
> How can I set the startup environment in sqlplus on unix? For example, I
> would like to have something like 'set pagesize 50' and 'alter session set
> NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';' when I startup the sqlplus.
>
> I tried to put it on ~oracle/login.sql but it looks like the environment only
> start up only if I logon sqlplus from directory ~oracle.
>
> Thanks.
>
> Ed
>
Set your environment variable SQLPATH to include the login.sql path
hope it help.
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 27 1999 - 10:55:36 CET