Re: how to initialize sqlplus settings?

A better method is to create an environment variable called SQLPATH. Add any directories (seperated by ';') that you place your scripts in. This way you don't have to include the path with the script name (as long as the script is in one of the directories specified in SQLPATH). Then put the login.sql file in one of those directories. Whenever you launch SQL*Plus, if LOGIN.SQL is not found in the current directory, it will find it in the path.

HTH,
Brian

Jerry Gitomer wrote:
>
> Create a login.sql file in the directory you launch SQL*Plus
> from. It can contain any valid SQL or SQL*Plus statements
>
> hth
> jerry gitomer
>
> David Zlotchenko wrote in message
> <81u3b9$oh1$1_at_penn.dii.utk.edu>...
> |Hi,
> |
> |I suspect there is a way to put some sort of .sqlplusrc file
> |in my unix home dir to set my preferences such as pagesize and
> |colsep automatically every time I start sqlplus interectively
> |or in batch.
> |
> |Can someone tell me if this is possible, what is the file
> |name, and how entries should look like?
> |
> |Can I put sql statements in?
> |
> |Thanks. David.
> |--
> |--
> |David Zlotchenko
> |E-mail: zlotchen_at_cs.utk.edu
> |WWW: http://www.oars.utk.edu/~zlotchen
Received on Tue Nov 30 1999 - 08:01:58 CST