Re: Working directory in SQL*Plus.

From: Paul <paul_at_not.a.chance.ie>
Date: Mon, 7 Jun 2004 09:50:08 +0100
Message-ID: <MPG.1b2e3c98b14d039c989948_at_news1.eircom.net>


[Quoted] gooiditweg_at_nospam.demon.nl says...

> >But, under windows at least, if I do 'pwd' under SQL*Plus, there is no
> >pwd parameter. 'show pwd' doesn't work either.
 

> is a command line tool, and doesn't exist in Windows. Just type
> host cd

[Quoted] This shows 'C:\' if I type it while running sqlplus in a dos window, but under the GUI, the screen just flashes (presumably, the dos window springs up and is closed again immediately). Doing just 'host' on its own, puts you into a dos window where you can issue host commands and see the output (however, see below).

The script does indeed work if I put it in 'C:\', but as you can imagine, that's not something that I want to be doing.  

> >I couldn't find that either under windows. I issued the 'show
> >parameters;' command which gave me lots of stuff, but nothing of any
> >help from what you've offered.
 

> either create this as a string value in the registry under
> hkey\local_machine\software\oracle\<yourhome>

[Quoted] Set up what exactly in there? I tried putting in a variable 'HOME' and gave it the value 'G:\Paul', and put the script in there, but it didn't work - even after rebooting.

> or set this up as an environment variable on the My computer
> properties

[Quoted] I already have a variable 'HOME' = 'C:\Documents and Settings\Paul' in there - which is why I was surprised that the script didn't work when I put it in there (see original post). What should it be called?

> Alternatively, you may want to create a shortcut on your desktop, with
> the correct working directory as the working directory of the
> shortcut.

[Quoted] OK - that worked. I now have a shortcut on my desktop which will run the script automatically from G:\Paul.

That's great, and thank you for your input.

Now, I have one final question - I like to use many rather than few directories to organise my scripts &c., and would like to organise them, say in Paul\C1, Paul:\C2 &c. for chapters 1, 2 &c...

[Quoted] How do I tell SQL*Plus to move between directories? I've tried 'host cd g:\Paul\c1' (to where I removed the script), but when I exit the dos window and go back to the gui tool, it appears that it is still stuck in g:\Paul. host dir still gives me g:\Paul and the script fails. It also fails if I use sqlplus from the dos window.

> It looks like you may want to improve on your Windows skills

[Quoted] I don't know if my Windows skills are that bad 8-). I'm on my own here and, as I said, going through this book. Now, I can always reinstall if I mess up catastrophically, but that takes a long time. For example, I assumed that my 'HOME' variable under Windows would be the default one for the tool, and was surprised to learn that it was 'C:\', which I can't for the life of me understand.

Thanks for your help so far.

Paul...

-- 
plinehan  y_a_h_o_o  and d_o_t  com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.

"XML avoids the fundamental question of what we should do, 
by focusing entirely on how we should do it." 

quote from http://www.metatorial.com 
Received on Mon Jun 07 2004 - 10:50:08 CEST

Original text of this message