1 Reply Latest reply: Jul 1, 2013 12:53 AM by Marwim RSS

    How do I make a command loop three times?

    aec994c5-48be-476e-88e3-7c77e0947223

      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

        • 1. Re: How do I make a command loop three times?
          Marwim

          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 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