Re: Working Directory in SQL+

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Thu, 08 Apr 1999 17:55:23 GMT
Message-ID: <370decdd.22612775_at_news.erols.com>

On Thu, 08 Apr 1999 10:53:28 -0400, Stephen Hirsch <Stephen.Hirsch_at_pharma.novartis.com> wrote:

>Hi,
>
>Is it possible to set the working directory in SQL+ via the command
>line? Specifically, I have several scripts that reside in and reference
>different directories (which I didn't write). Right now, I have to open
>a file that I don't execute to change the working directory, which is
>annoying.

Try setting the SQLPATH environment variable. In Unix, set an environment variable called $SQLPATH, in Window set the it in the registry along with the other Oracle parameters (hkey_local_machine \ software \ oracle).

This is a "search path" for SQL*Plus. It will look in the directories specified there for SQL files if not found in the current directory.

For instance, on my client machine it is set to:

  e:\dba\sql;e:\wss\sql;e:\dba\new;D:\orant\DBS;d:\orant\plus80

On my server it is set to:

  /opt/local/sql:/export/home/chris/sql

Chris

---

Christopher Hamilton
Oracle DBA -- Wall Street Sports
chris_at_wallstreetsports.com
http://www.wallstreetsports.com/ Received on Thu Apr 08 1999 - 19:55:23 CEST