title: PLSQL populate a table with all dates within two dates
body: <p>So I'm trying to populate a table with dates from January 1 1960 to December 2020. I tried a writing a query however I'm quite new to plsql that I'm afraid I must of messed up somewhere as this does nothing.</p>
  
  <pre><code>DECLARE
      start_date DATE;
      end_date DATE;
  BEGIN
      start_date := '01-jan-1960';
      end_date := '31-dec-2020';
  
      LOOP
          INSERT INTO samp VALUES(start_date);
          start_date := start_date + 1;
          EXIT WHEN start_date = end_date;
      END LOOP;
  END;
  </code></pre>
  
  <p>Any help would be much appreciated.</p>