title: How to use for loop for insert in Oracle?
body: <p>I'm having trouble inserting 1 million records in Oracle using the following for loop. The insert statement works on it's own but not inside the loop. What am I doing wrong here?</p>
  
  <pre><code>BEGIN
      FOR v_LoopCounter IN 385000000..1000000 LOOP
          INSERT INTO PORT (snb, real_exch, act_exch, user_type, status_id, category_id, assignable) 
              VALUES (TO_CHAR(v_LoopCounter),'GSMB','GSMB','GSM',0,90,'0');
          COMMIT;
      END LOOP;
  END;
  </code></pre>