修改SQLPATH

设置这个东西后，运行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