René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

SQLPATH [SQL*Plus]

When an SQL script file (a file containing SQL statements) is executed with start, the file is searched in the current directory and the directory specified with the environment variable SQLPATH. (On Windows, it's also possible to specify these directory via the registry.

Starting SQL*PLUS

Whenever SQL*Plus is started, it looks for a file named login.sql in the directory specified with $SQLPATH and, if existant, executes it.

On Windows...

On Windows, there is also the possibility to set the SQLPATH in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\{oracle_home}\SQLPATH