Re: set up a drive path
Date: 1999/09/18
Message-ID: <37e34ef8.14635279_at_news.demon.nl>#1/1
The best way to do this seems to be the following:
create a shortcut on your desktop for sqlplus.
Change the working directory from %ORACLE_HOME%\bin to whatever you
want. I wouldn't use the A drive, I usually locate my scripts in
\oradba\sql outside the Oracle_home tree.
The make sure you include that directory in the SQLPATH registry key
in HKLM\software\oracle.
Please also note you can use environment variables in sqlplus, so
spool %TEMP%\output.lst
does work.
Hth,
Sybrand Bakker,Oracle DBA
On Fri, 17 Sep 1999 12:57:30 -0400, RC <rc_at_neomenia.com> wrote:
>Anyone know how set up pl/sql to open the a: drive when editing a script
>at the sql prompt? I don't want it to and save in my bin.
>
>greatly appreciated
Received on Sat Sep 18 1999 - 00:00:00 CEST