Re: SQL*Plus - setting a working directory

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: 1997/07/24
Message-ID: <33d69c42.4224158_at_newshost.interact.net.au>#1/1


On Tue, 15 Jul 1997 21:04:44 -0700, John C <johnjc_at_ns.net> wrote:

>Fuzzy wrote:
>>
>> Hi people,
>>
>> I'm using SQL*Plus a great deal now-a-days (yes, I have sought medical
>> help for this), and I'm of course writing a lot of scripts to make my
>> life easier. However, these scripts live in a directory (on a win95
>> machine) called
>>
>> f:\db\oracle\scripts
>>
>> I'm getting tired of writing this every time I use '_at_' or 'start', so
>> I was wondering if there is parameter for SQL*Plus that defines what
>> path to check for scripts by default? Or does it pick up one of my
>> environment variables like PATH?
>>
>> Thanks
>> Fuzzy
>> :-)
>
>Try this. Setup a shortcut to SQL*Plus. Right mouse click on it and
>choose Properties. On the Shortcut tab, in the Start In field, keyin
>your directory path. This establishes that directory as the working
>directory when SQL*Plus loads.
>You can also automatically login to the database. In the Target field,
>add a space and your userid/password_at_connect after the .EXE. Rename the
>shortcut so you know that this one is special.
>Drag and drop the shortcut to your desktop, the Start button or some
>other favorite locale. You should login to the DB AND have your working
>directory all set.
>
>John johnjc_at_ns.net

I can't believe I didn't think of this.

Thanks John.

Grant
:-) Received on Thu Jul 24 1997 - 00:00:00 CEST

Original text of this message