title: How to populate calendar table in Oracle?
body: <p>I want to maintain a calender table in Oracle DB which I want to populate with all the days of the year starting from 2011 to 2013 (it may be till any year). How can I do that?</p>
  
  <p>Consider my DB table has columns and example dataset is:</p>
  
  <pre><code>S.No  Cal_Dt      DayName 
  1     01-01-2011  Monday
  2     02-01-2011  Tuesday
  3     03-01-2011  Wednesday
  </code></pre>
  
  <p>and so on. </p>
  
  <p>I am more concerned with the Cal_Dt only here (DayName is optional).</p>