I am currently having trouble making my select statement run three times. Is there any way I can make it work?
Here's my current code:
create sequence MY_FIRST_SEQ increment by -3 maxvalue 5 start with 5 minvalue 0 nocycle;
Message was edited by: aec994c5-48be-476e-88e3-7c77e0947223
this is the forum space for the tool SQL Developer. As the title clearly says it is (Not for general SQL/PLSQL questions).
Please post your question in PL/SQL and SQL
When posting there you should explain your business case, this means: What do you want to do.
making my select statement run three times
Do you want to run the same statement three times? Three times with a pause in between? What do you want to do with the result?
Also a sequence is only there to generate numbers. It's not there to control the execution of a statement.