Re: SQLPLUS login script

You could set SQLPATH=.:$HOME/sql to use the one in the current directory, if none found it would use the one in your_home_directory/sql directory.

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?
: >
: > Please send me a mail if you have the solution.
: > Thanks ... Tom
: > ====================
: > Nortel
: > tchow_at_nortel.com
 

: Hi there
 

: In our environment, we have made an alias for sqlplus.
 

: alias s = "sqlplus scott/tiger _at_$HOME/bin/login.sql"
 

: Every time you use 's', it will connect to the database and will automatically
: execute login.sql.
 

: I think you can use alias 'sqlplus' instead of above 's'.
 

: Regards
 

: N.Prabhakar

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.