Re: Run command on sqlplus repetitively without reconnection.
From: rjamya <rjamya@xxxxxxxxx>
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.