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