title: Insert 1000 rows in single sql statment or procedure
body: <p>How should i write a single sql statement or a stored procedure, </p>
  
  <p>To insert 1000 values in 1000 rows and same column with each column having different values (among those 1000)</p>
  
  <p>Here is the query i wrote,</p>
  
  <pre><code>INSERT INTO a_b values
  (
    (SELECT max(a_b_id) + 1 from a_b),
    1111,
    (SELECT s_id FROM a_b WHERE s_id in ('0','1','2','3','4')),
    0,
    1,
    sysdate,
    sysdate,
    0,
    1,
    null
  );
  </code></pre>
  
  <p>like say, i have 1000 s_id's i want select them one by one and insert them in one particular column, each time creating a new row. </p>
  
  <p>EX, in first row s_id should be 0 then in second row it should be 1 like that goes on till thousand, attached an image of sample database i am working with.</p>
  
  <p><a href="https://i.stack.imgur.com/APGkm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/APGkm.png" alt=""></a></p>