Re: Working directory in SQL*Plus.

Paul wrote:

> Hi all,
>
>
> I am working my way through "Beginning Oracle Programming" by Dillon,
> Beck, Kyte & al.
>
> Now, around p. 139, they start to introduce the idea of running scripts,
> which is all fine and dandy, so they give an example of a script and say
> that if you place this *_IN YOUR WORKING DIRECTORY_*, it will run thus
>
> SQL> connect hr/hr
> SQL> _at_myscript
>
> so, I tried putting the file into C:\Documents and Settings\Paul and
> also C:\Documents and Settings\Paul\My Documents, which I thought were
> the two standard windows working dirs. But it can't find them. If I
> include _at_'C:\Documents and Settings\Paul\myscript.sql' it works fine,
> but I don't want to have to specify the path all the time.
>
> Could someone tell me where I have to put the script so that it will
> work with simply a _at_myscript? Using W2000 Pro, Oracle 9.2.0.1.0.
>
>
> TIA.
>
>
> Paul...

[Quoted] [Quoted] IIRC, the concept of "working directory" comes from *nix. [Quoted] You can see your current directory by issuing the "pwd" command; [Quoted] which Prints Working Directory; which is the directory into which you last cd'ed into.

[Quoted] [Quoted] Also if setup correctly SQL*Plus will search the folders which are enumerated by the SQL_PATH environmental variable. Received on Sun Jun 06 2004 - 21:49:17 CEST