Environment Variables That Affect SQL*Plus
A number of environment variable settings affect the behavior of SQL*Plus. The following sections describe some commonly used environment variables. For detailed descriptions of all the environment variables applicable to your version of SQL*Plus, consult your manual.
Specifying a Search Path for Scripts
Use the SQLPATH environment variable to designate one or more directories containing .sql files you wish to invoke from the SQL*Plus command prompt. Here are two from Linux:
These commands designate a search path consisting of two directories, which are separated by colons. When you execute a script using this SQLPATH setting, SQL*Plus will search the following directories in order:
Your current working directory, which is the directory you were in when you started SQL*Plus
On Windows systems, you set environment variables from the Advanced tab of the System Control Panel, after clicking the Environment Variables button, as illustrated in Figure 14-1.
A Windows install of Oracle Database 10g includes a default SQLPATH specified in a registry entry such as the following:
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1 ...