# Rerun sql statement

**URL:** <https://community.unix.com/t/rerun-sql-statement/242142>\
**Category:** Shell Programming and Scripting\
**Created:** [June 9, 2009, 8:03pm UTC](https://community.unix.com/t/rerun-sql-statement/242142 "2009-06-09T20:03:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![killboy](https://community.unix.com/letter_avatar/killboy/32/5_5575768a8748004e209b776fc1b2916d.png) [@killboy](https://community.unix.com/u/killboy)\
**Post date:** [June 9, 2009, 8:03pm UTC](https://community.unix.com/t/rerun-sql-statement/242142/1 "2009-06-09T20:03:05Z")

</div>

Hi,

Script that I wrote only run sql query once then exit. But my requirement, I want the query can be execute a couple of time without exiting the script. How could I do it? Thanks.

---

<div class="post-metadata">

**Author:** ![radoulov](https://community.unix.com/user_avatar/community.unix.com/radoulov/32/489_2.png) [@radoulov](https://community.unix.com/u/radoulov)\
**Post date:** [June 10, 2009, 7:16am UTC](https://community.unix.com/t/rerun-sql-statement/242142/2 "2009-06-10T07:16:42Z")

</div>

You could run the statement in a PL/SQL loop.