A
Customizing Operating System Parameters

This chapter describes how to customize your SQL*Plus configuration by changing the SQLPATH parameter in the registry.

Specific topics discussed are:

• Using the Registry
• SQLPATH Parameter Description

 

Warning: Editing the registry may affect your application's user interface. Only advanced users should edit the registry.

Using the Registry

When you install Oracle products for Windows NT 4.0 or Windows 95/98, Oracle Universal Installer adds relevant parameters to the registry.

The following table indicates which registry version(s)--REGEDT32.EXE and/or REGEDIT.EXE--you can use for your particular Windows platform:

Windows Platform	REGEDT32.EXE	REGEDIT.EXE
Windows NT 4.0	YES	YES
Windows 95	NO	YES
Windows 98	NO	YES

The HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE subkey contains the Oracle parameters.

See the registry's Help system 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.

SQLPATH Parameter Description

This section describes the only registry parameter that is relevant to SQL*Plus for Windows NT and Windows 95/98--SQLPATH.

Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

Default Value: ORACLE_BASE\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.

When you set the SQLPATH parameter, directories can be concatenated with a semicolon (;). For example:

C:\ORACLE\ORA81\DATA;C:\ORACLE\ORA81\DBS