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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Run command on sqlplus repetitively without reconnection

Re: Run command on sqlplus repetitively without reconnection

From: Philip Douglass <philipsd_at_gmail.com>
Date: Wed, 23 May 2007 16:54:34 -0400
Message-ID: <86de47840705231354g6ce65ba2m7a76fcffdaaae043@mail.gmail.com>


It's been a while since I made this little script, and for the life of me, I can't remember why I used the '--', but I'm sure I had a good reason for it. ;)

Anyway, glad you like it.

On 5/23/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> On 5/23/07, David Taft <oradbt054_at_gmail.com> wrote:
> >
> >
> > The part I'm not completely sure about is the double-dash (--). The AIX
> > man page for ksh is very sparse. I went to publib.boulder.ibm.com/.../korn_shell_enhanced.htm
> > under "Coproces facility", but didn't find any help there. I did find
> > some info under the getopts command that makes me think the double-dash is
> > just a kind of terminator that says "don't check for any more options after
> > -p. Is that correct?
> >
> >
>
> The -- is not specific to co-processes, but is used to tell the shell to
> stop looking for options on the command line, and consider everything
> following the -- as an argument.
>
> eg. Create a file named '-i'
>
> Now try to delete it with 'rm -i'.
>
> This obviously won't work, but 'rm -- -i' will work.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 23 2007 - 15:54:34 CDT

Original text of this message

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