Execute sql query in loop
I am trying to execute the following statement in Oracle isql*plus, but i am getting error message. Could anyone help?
for a in 1 .. 10 loop
i := 'select count(*) from messages';
a := a + 1;
All I would like to do is to run the statement of "select count(*) from messages" in every second, so I was trying to do it in for loop so that I don't need to click execute button in every second.