|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.
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, there is also the possibility to set the SQLPATH in the registry: