Execute sql query in loop
Hi guys,
I am trying to execute the following statement in Oracle isql*plus, but i am getting error message. Could anyone help?
declare
i varchar(200);
begin
for a in 1 .. 10 loop
i := 'select count(*) from messages';
dbms_output.put_line (i);
a := a + 1;
end loop;
END;
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.
Thanks