Re: set up a drive path

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 - 03:39:24 CDT