Re: Working directory in SQL*Plus.

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 07 Jun 2004 00:13:33 +0200
Message-ID: <3g57c011oa1ebm70hksu5tus2o0gvsrf4o_at_4ax.com>


On Sun, 6 Jun 2004 23:01:26 +0100, Paul <paul_at_not.a.chance.ie> wrote:

>
>
>anacedent_at_hotmail.com says...
>
>> IIRC, the concept of "working directory" comes from *nix.
>
>
>Yes, and that's fine, but as I said, I'm using windows. I do know a bit
>of Unix/Linux, but I'm not working under that at the moment. I plan to
>later.
>
>
>> You can see your current directory by issuing the "pwd" command;
>> which Prints Working Directory; which is the directory into
>> which you last cd'ed into.
>
>
>But, under windows at least, if I do 'pwd' under SQL*Plus, there is no
>pwd parameter. 'show pwd' doesn't work either.
>
>

[Quoted] is a command line tool, and doesn't exist in Windows. Just type

host cd

>> Also if setup correctly SQL*Plus will search the folders
>> which are enumerated by the SQL_PATH environmental variable.
>
>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.

[Quoted] either create this as a string value in the registry under hkey\local_machine\software\oracle\<yourhome> [Quoted] or set this up as an environment variable on the My computer properties (right click my computer, click properties, click the advanced tab, choose environment variables) [Quoted] Alternatively, you may want to create a shortcut on your desktop, with the correct working directory as the working directory of the shortcut.
>
>Thanks anyway for your input.
>
>
>Paul...

[Quoted] It looks like you may want to improve on your Windows skills

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Jun 07 2004 - 00:13:33 CEST

Original text of this message