Re: SQLPLUS login script

In article dated 22 Nov 1996 00:31:38 GMT, N Prabhakar (N_Prabhakar_at_Socgen-Crosby.com) wrote:
> Tom Chow <tchow_at_nortel.com> writes: > I would like to start my own login.sql on top of the system-wise
> > glogin.sql. However, SQLPLUS does not pick it up from the current
> > directory. What variable I should set up in the HP UX enviornment
> > to tell SQLPLUS to execute my login.sql automatically if it is found?
>
> In our environment, we have made an alias for sqlplus.
>
> alias s = "sqlplus scott/tiger _at_$HOME/bin/login.sql"

This works for AIX 4.1.4 & ksh

SQLPATH=.:/home/we87598/sql; export SQLPLATH

SQLPlus will then pick up login.sql in the current directory '.' or from /home/we87598/sql.

Check you UNIX Administration manual or Installation guide.

-- 
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."