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: SQLPLus Host command shortcut

Re: SQLPLus Host command shortcut

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 25 Aug 2006 02:00:25 -0700
Message-ID: <1156496425.576030.115170@p79g2000cwp.googlegroups.com>

Rene Nyffenegger schreef:

> On 2006-08-23, dm1959_at_tampabay.rr.com <dm1959_at_tampabay.rr.com> wrote:
> > I am in the process of moving some Unix Oracle databases to Window
> > environment and thus far, working well. I have some deploy scripts
> > though that are using the Host command in this form of: !mkdir
> >
> > On the Unix environment it works well but on the windows environment I
> > get errors that this command is unknown. I did discover that I can
> > using the shortcut of: $mkdir.. Is there anyway that I can change the
> > default shortcut from $ to ! And then I don't have to change all of my
> > shell scripts. I also recognize that I could change my shells properly
> > so that they call: HOST mkdir but was just wondering if I could change
> > it prior to me making all of the rest of the changes. So basically,
> > long term I would change to HOST but short term for test purposes I
> > would like to me able to do" !mkdir in windows.
> >
> > Any help you can provide is most appreciated.
>
> I think that's less of an Oracle related question than some
> scripting/perl/python/whatever related question.
>
> It seems to me that you need a script of some sort that takes
> your scripts and finds ! as first character in each line and
> replaces the ! with $.
>
> hth,
> Rene
>
>
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch/

sed s/!/\$/g

sed can be found for Windows, e.g. cygwin (which will even allow you to run your scripts unmodified!) Received on Fri Aug 25 2006 - 04:00:25 CDT

Original text of this message

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