Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where should place my sql scripts?

Re: Where should place my sql scripts?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Wed, 23 Apr 2003 08:42:15 GMT
Message-ID: <mfkcav4e81dpg02hfnv4hg5oaea5vu2npu@4ax.com>


On Wed, 23 Apr 2003 08:44:20 +0200, "Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote:

Yes this helps a lot, thanks.

>"Peter" wrote...
>>
>> I am rnnning Win2000. sorry that I left that out.
>>
>> >"Peter" wrote...
>> >> Sqlplus is complaining that it cannot find my scipts.
>> >> Can I specify where the scripts are in the sql command?
>
>Hi Peter,
>
>my favourite way for doing this is:
>- create a shortcut to the GUI sql*plus (e.g. plus80w.exe)
>- modify the property working directory in this shortcut
> to your needs
>- BINGO.
>
>I use this way because I work on many different procects (nearly)
>simultaneously. I create shortcuts for every project. That prevents me
>from logging into the wrong database etc. It allows me to store specific
>scripts in the project's directory structure.
>
>But if your just have one project, I think, setting SQLPATH is the way to
>go.
>
>Greetings,
>Guido
>directory and use them
>
Received on Wed Apr 23 2003 - 03:42:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US