Re: I want to change directory inside SQL script
- From: Thiru Pandian <tpandian@xxxxxxxxx>
- To: "Gracelin Priya S." <GracelinP@xxxxxxxxxxx>
- Date: Thu, 27 Jan 2005 10:13:26 -0500
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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thiru Pandian
> Sent: Thursday, January 27, 2005 8:03 PM
> To: Oracle-L@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
Thiru Pandian
Sr. Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
