Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where should place my sql scripts?
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
![]() |
![]() |