Re: Run command on sqlplus repetitively without reconnection.

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.


Other related posts: