title: Database Date: How to auto increment the date automatically in a table?
body: <p>I created a Database called DatesOfYear</p>
  
  <pre><code> CREATE TABLE DATESOFYEAR
   (
   MyName varchar(15),
   MyDate date
   );
  </code></pre>
  
  <p>and i inserted a value in it  </p>
  
  <pre><code> INSERT INTO DATESOFYEAR VALUES ('FName','1-JAN-2017');
  </code></pre>
  
  <p>The output is  </p>
  
  <pre><code> MYNAME     MYDATE
   FName      1-JAN-2017
  </code></pre>
  
  <p>How do i increment the <code>MyDate</code> from <code>1-JAN-2017</code> up until the end of year which is <code>31-DEC-2017</code>, the output that i want to see is</p>
  
  <pre><code> MYNAME     MYDATE
   FName      1-JAN-2017
   ....          ....
   FName      31-DEC-2017
  </code></pre>