Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Set SQLPlus Default Directory

Re: Set SQLPlus Default Directory

From: Mike Proctor <mp_at_mg-tc.demon.co.uk>
Date: 1997/01/02
Message-ID: <oMFpqIAOszyyEwVR@mg-tc.demon.co.uk>#1/1

In article <32C847A9.56D9_at_medtronic.com>, Barry Schader <barry.schader_at_medtronic.com> writes
>Marc Scheuner wrote:
>>
>> dmausner_at_brauntech.com (Dave Mausner) wrote:
>>
>> >>How can I set the default directory where SQLPlus looks for scripts to run.
>> >>For example, I put all my scripts in c:\scripts. When I do a @myscript in
>> >>SQLPlus, I want it to look in c:\scripts for myscript.
>> >
>> >set environment variable in autoexec.bat:
>> >set SQLPATH=c:\scripts
>> >
>>
>> Unfortunately, this doesn't work when using SQL*Plus 3.3 (Win16
>> version) on a Win NT 3.51 machine.
>>
>> Any idea how I can get it to work in my configuration??
>>
>> Marc
>
>I have SQL*Plus 3.2.2 on NT 3.51 and this works for me:
>Go into Control Panel, then System, and set SQLPATH under
>the User Environment Variables for <account>. It probably
>also would work as a system environment variable, too.
>
>Barry Schader
>barry.schader_at_medtronic.com

Alternatively you might try setting the program item property 'working directory' to the directory where you are currently running the scripts.

I keep a separate icon, and can therfore have, a separate working directory for each set of scripts/project (in fact I often set up a new program group for each new project). That way I can change script sets (directories) without editing anything and/or re-booting, just exit that instance of SQL*Plus and start the one you want to use with the new default directory.

Mike Proctor

mp_at_MG-TC.demon.co.uk

Oracle vision.
Only Oracle.
All the time.

Turnpike evaluation. For information, see http://www.turnpike.com/ Received on Thu Jan 02 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US