Re: QUESTION running scripts in different directores...
Date: Sat, 10 Apr 1999 02:53:29 GMT
Message-ID: <J2zP2.2483$h4.317_at_tundra.ops.attcanada.net>
Lakshne,
If I had understood your question that you want to run differenct sql scripts created in different directories, Yes it is possible,
Create one master script and put all the scripts which you wish to run as following in master scritp.
_at_/xyx/abc/test1.sql
_at_/bbb/ttt/dddd/test2.sql
and run your master_script.sql at command line as following.
sqlplus scott/tigger _at_master_script.sql
I hope this answer your question
Nisar Tareen
ntareen_at_allianz.ca
Canada.
LAKSHNE <lakshne_at_aol.com> wrote in message
news:19990408225534.05164.00000423_at_ng119.aol.com...
> Hi,
>
> Is it possible to set the working directory in SQL+ via the command
> line? Specifically, I have several scripts that reside in and reference
> different directories (which I didn't write). Right now, I have to open
> a file that I don't execute to change the working directory, which is
> annoying.
>
> Thanks for your help.
> Vijaya
>
Received on Sat Apr 10 1999 - 04:53:29 CEST