设置这个东西后,运行SQLPLUS就会自动从这里加载一些sql。
When an sql statement file 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