(SQL Plus|SQL Developer)- SQLPATH

Card Puncher Data Processing


Setting up the SQLPATH environment variable in the windows environemnt tell SqlPlus - SqlPlus Command to search the file in this directories.

The startup files (login.sql,…) must be located in this directories.

Bug: SQLPlus doesn't search in the subdirectory and the length of the variable must not be greater than 254 (The reality is between 241 and 278)

SQLPATH can be by default created in the registry (in 12c it's the case) with this value: oracle_home\dbs

SQLPLUS first searches:

  • the user's current working directory,
  • then uses the following user-defined environment variable if defined:
    • ORACLE_PATH for Unix environment or
    • SQLPATH for Windows environment.
  • otherwise it will use the registry value for windows (HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0)

SQL Developer

Tools > Preference:

Sqldeveloper Sqlpath

Example on my computer

echo %SQLPATH%

Discover More
Oracle Registry Windows
Oracle Database - Environment Variables / Registry Values

To configure the database installation, Oracle provide several Environment variable / Registry Value. : oracle_sid is used for a local connection - direct to the server - without using a listener...
Card Puncher Data Processing
SQL Plus - Configuration

See: Buffer configuration Configuring SQLPlus Tns Names Configuration
Card Puncher Data Processing
SQL Plus - Start Command

Runs the SQLPlus statements in the specified script. The script can be called from the local file system or a web server. where: url supports HTTP and FTP protocols in the form: ...
Card Puncher Data Processing
SQL Plus - Startup Script

This article talks how to configure the environment variable when start up in order to have always a good behaviour in the formatting of the result. You have to setup the with a directory. Copy...

Share this page:
Follow us:
Task Runner