1 Reply Latest reply on Jul 1, 2013 5:53 AM by Marwim

    How do I make a command loop three times?

    aec994c5-48be-476e-88e3-7c77e0947223
    aec994c5-48be-476e-88e3-7c77e0947223 Jun 28, 2013 6:10 PM

      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

      • 253 Views
      • Tags:
        • 1. Re: How do I make a command loop three times?
          Marwim
          Marwim Jul 1, 2013 5:53 AM (in response to aec994c5-48be-476e-88e3-7c77e0947223)

          Hello,

           

          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 SQL & PL/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.

           

          Regards

          Marcus