After i sent the mail, i had to write a shell script to do that. I
was wondering any other way to change inside sql.
On Thu, 27 Jan 2005 20:27:28 +0530, Gracelin Priya S.
<GracelinP_at_quark.co.in> wrote:
> Is ur oracle is in Windows or Unix??
>
> If it is windows write a bat file that will call script1,then change the directory and then the script2
>
> If it is unix do it in a shell script..
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thiru Pandian
> Sent: Thursday, January 27, 2005 8:03 PM
> To: Oracle-L_at_freelists.org
> Subject: I want to change directory inside SQL script
>
> Hi,
>
> I want to change the directory from sql script. I am applying few
> application patches which requires punch of sql needed to be run from
> different directory, i would like to automate this.
>
> @script1
> change the directory
> @script2
>
> you may say that i should do @@ or specify the directory for parent
> script. But in the script they did not have @@. Is there any way do
> this?
>
> --
> Thiru Pandian
> Sr. Oracle DBA
> --
> http://www.freelists.org/webpage/oracle-l
>
>
--
Thiru Pandian
Sr. Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 27 2005 - 10:16:37 CST
