startup environment in sqlplus?
From: <ewong74_at_netscape.net>
Date: Tue, 26 Jan 1999 20:21:02 GMT
Message-ID: <78l834$ciu$1_at_nnrp1.dejanews.com>
Hi,
Date: Tue, 26 Jan 1999 20:21:02 GMT
Message-ID: <78l834$ciu$1_at_nnrp1.dejanews.com>
Hi,
[Quoted] 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
[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 26 1999 - 21:21:02 CET