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

you can also get the properties of the shortcut you are working from and edit the start in field.

TurkBear wrote:

> You can also place an entry in the registry under HKLM/Software/Oracle add a new string value ( if there is not one already -
> sometimes it has a default one set to ORACLE_HOME/dbs ) called SQLPATH and set its value to the directory ( or directories
> separated by semi-colons, like regular PATH statements) you want to run scripts from..SqlPLus will search these in the order
> they appear..
>
>
> Thomas Gaines <Thomas.Gaines_at_noaa.gov> wrote:
>
> >
> >
> >Brian E Dick wrote:
> >
> >> I believe if you use @@xxxx sqlplus will run the called script from the same
> >> directory as the calling script.
> >>
> >
> >Ahh. Interesting. I'll give it a try.
> >
> >In the meantime, I'm happy to report that I found a suitable solution to my
> >problem.
> >I'm used to running the GUI version of SQL*Plus on my Win2000 machine, but if
> >I set the SQLPATH environmental variable (set SQLPATH=f:\) and then invoke
> >SQL*Plus from cmd.exe window, this all works just great.
> >
> >But I'll give your approach a try, too.
> >
> >Thanks very much, Brian.
> >
> >Tom
> >
> >>
> >> "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 Thu Jan 30 2003 - 10:37:53 CST