title: How to retrieve data for every single day in a period in SQL?
body: <p><strong>What I want:</strong></p>
  
  <p>I want to have the work model for every single day in a period and for every single employee. That is, i have a table containing work models for all employees of a company. The work models are assigned for a certain period to employees. So, an employee may have more than one work model in a year. So what i want to do is to retrieve the work model for every single day in any date range and for any single employee. Is it possible in SQL? If yes, how should I proceed?  </p>
  
  <p>I´m working with SQl Developper version 3.0.04. The database is from Oracle.</p>
  
  <p>For a better unterstanding of my problem follow the link below to have a look at the schema of the table containing the data as well as of the table which shows how the result of my query should look like.</p>
  
  <p><a href="http://www.sqlfiddle.com/#!4/4a167/4" rel="nofollow">Link to SQLFiddle for the Schemas</a></p>
  
  <p>Table employee shows the table containing the work models assigned to employees and which period the´re valid for. The first row indicates that employee 1 has been assigned the work model 52101 from 01.01.2000 to 21.06.2009.</p>
  
  <p>Table result shows how the result of my query for a date range should look like. Date range is from 19.02.2013 to 23.02.2013.</p>
  
  <h2>I used the following SQL query to generate days in the date range:</h2>
  
  <pre><code>SELECT to_char(trunc(to_date('19.02.2013'))-1+rownum,'dd/mm/yyyy') days
  FROM all_objects
  WHERE ROWNUM &lt;= (to_date('23.02.2013') - to_date('19.02.2013'))+1
  </code></pre>
  
  <hr>
  
  <p>Notwithstanding I can´t come forward to assign for every single day and for every single employee the right work model.</p>
  
  <p>thanks in advance for answering.</p>