Re: Run command on sqlplus repetitively without reconnection.

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: mwf@xxxxxxxx
  • Date: Thu, 10 May 2007 07:34:08 -0400

when faced with such issues, I encapsulate such queries into pipelined
functions. I can control the frequency at which these should execute and the
query as well. I normally output one (formatted) column. Stays in the db,
works on 9i and 10g.

rjamya

Other related posts: