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

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 Wed Jan 29 2003 - 16:07:00 CST