Hi all,
I want to run a SELECT on a table every minute during half an hour.
Something like this :
Begin
Do every 1 minute during 30 Min
Select col1, col2 from mytable
End
I thought of Loop in PL/SQL. But did'nt see any example with time indication.
Any way ?
Thanks and regards.