SQL*Plus Getting Started Release 8.0.4 for Windows NT and Windows 95 A55973-01 |
|
This chapter describes how to customize your SQL*Plus configuration by changing parameters in the registry.
Specific topics discussed are:
When you install Oracle products for Windows NT/95, Oracle Installer adds relevant parameters to the registry. You can examine these parameters by running one of the following programs:
The HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE subkey contains the Oracle parameters.
See the registry's online help for instructions on how to edit the parameters.
If you change the value of an Oracle parameter or add a parameter to the registry, the change will take effect whenever SQL*Plus executes a procedure that uses the parameter.
This section describes the registry parameters that are relevant to SQL*Plus for Windows NT/95.
Default Value: ORACLE_HOME\PLUS80
Valid Values: any directory on any drive
This parameter specifies the location of the SQL*Plus files, including the GLOGIN.SQL file. In addition to searching the directory specified by PLUS80, SQL*Plus also searches the current directory for SQL*Plus files.
The first four characters of this parameter, PLUS, refer to SQL*Plus. The remaining characters correspond to the current version of SQL*Plus. Subsequent versions of SQL*Plus may use a different version number (for example, PLUS81) to enable you to keep multiple versions of SQL*Plus on your computer.
Default Value: PLUS80
Valid Values: any SQL*Plus executable, such as PLUS80 or PLUS80W
This parameter specifies the SQL*Plus executable to be spawned when SQLPLUS.EXE is started.
Default Value: ORACLE_HOME\DBS
Valid Values: any directory on any drive
This parameter specifies the location of SQL scripts. In addition to searching the directory specified by the SQLPATH parameter, SQL*Plus also searches the current directory for SQL scripts.
Note: SQL*Plus uses the PLUS80 parameter to specify the location of the GLOGIN.SQL script. Refer to "PLUS80" earlier in this appendix for more information. |
When you set the SQLPATH parameter, directories can be concatenated with a semicolon (;). For example:
C:\ORANT\DATA;C:\ORANT\DBS