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

There are those who have scripts in multiple directories and either use the SQLPATH method or create separate shortcuts ( using your 'start in' technique) for specific script directories ( like project-related subdirectories)..

Eric Kimble <ekimble_at_wfl.fha.dot.gov> wrote:

>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 - 12:52:46 CST