Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question - how do I choose my working directory?
"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote:
>Mark gave you a pointer for GUI sqlplus...
GUI sqlplus??? There isn't much of a GUI! It's the spit of 3.1 interface (a poor one at that!!!!)...
> I on the other hand only use
>command line sqlplus. I have created a simple batch script to launch
>sqlplus which just gives me a bit of control to change my working
>directory. You can substitute sqlplus with sqlplusw to use GUI version.
>This will only work on NT/2K/XP/2K3,
>@echo off
>set workdir=C:\My_Working_dir
>echo Specify working directory or hit enter to choose default %workdir%
>echo.
>set /P workdir=
>echo Working dir: %workdir%&echo.
>cd /d %workdir%
>if [%1]==[] (
> sqlplus /nolog
>) else (
> sqlplus %1
> )
Will look at it thanks. Now, for your bonus question, tell me how I can change the working directory from within a session!! 8-)
Paul...
>/Rauf
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2, Oracle 9.2.0.1.0 Received on Tue Mar 15 2005 - 17:56:26 CST