title: Using Oracle SQL, how does one output day number of week and day of week?
body: <p>Using Oracle SQL, how do you create a result set for:</p>
  
  <ul>
  <li>Number for the Day Of The Week (1-7)</li>
  <li>Name of the day (Monday, Tuesday, Wednesday, etc.)</li>
  </ul>
  
  <p>For example:</p>
  
  <pre>
  DAY   NAME
  1     Monday
  2     Tuesday
  3     Wednesday
  4     Thursday
  5     Friday
  6     Saturday
  7     Sunday
  </pre>