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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Way to set the prefix for use in an SQL*Plus start command ?

Re: Way to set the prefix for use in an SQL*Plus start command ?

From: Brian E Dick <bdick_at_cox.net>
Date: Wed, 29 Jan 2003 19:01:30 GMT
Message-ID: <eyVZ9.53774$GX4.2146359@news2.east.cox.net>


I believe if you use @@xxxx sqlplus will run the called script from the same directory as the calling script.

"Thomas Gaines" <Thomas.Gaines_at_noaa.gov> wrote in message news:3E3819DB.CFCF0193_at_noaa.gov...
> All -
>
> Are you aware of any way to set an assumed directory when using
> the SQL*Plus "start" command? My various SQL*Plus scripts live
> in directory f: on a Windows box, and those scripts have various "start"
>
> commands embedded in them. Do I have to edit each of those scripts
> so that they look like "start f:\xxxx.sql" instead of "start xxxx.sql" ?
>
> Just like SQL*Plus assumes an ".sql" for the suffix of a filename given
> in a "start" command, wouldn't it be cool for the user to be able
> to set the prefix?
>
> Thanks for your time.
>
> Tom
>
>
Received on Wed Jan 29 2003 - 13:01:30 CST

Original text of this message

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