Re: Run command on sqlplus repetitively without reconnection

  • From: "Philip Douglass" <philipsd@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 23 May 2007 16:54:34 -0400

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@xxxxxxxxx> wrote:

On 5/23/07, David Taft <oradbt054@xxxxxxxxx> 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
> 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

Other related posts: