title: Oracle Creating a view with specific records from a table
body: <p>I would like to create a view from the following table called TB_STATUS.</p>
  
  <pre><code>ID  EVENT_DATE       REOPEN_DATE
  1   16/1/2013 16:16 
  2   16/1/2013 16:38 
  3   16/1/2013 18:18 
  4   15/1/2013 0:00  
  5   16/1/2013 16:36  16/1/2013 0:00
  6   16/1/2013 17:12  16/1/2013 0:00
  7   4/1/2014 9:00    4/1/2014 0:00
  8   5/1/2014 14:00   5/1/2014 0:00
  9   4/1/2014 11:00  
  10  4/1/2014 16:00  
  11  4/8/2013 11:00  
  12  15/8/2013 1:00  
  </code></pre>
  
  <p>Expected view content is <code>MIN(EVENT_DATE)</code> in between REOPEN_DATE as follows:</p>
  
  <pre><code>ID  EVENT_DATE       REOPEN_DATE
      MIN(EVENT_DATE)
                       REOPEN_DT
      MIN(EVENT_DATE) 
                       REOPEN_DT
      MIN(EVENT_DATE) 
                       REOPEN_DT
      MIN(EVENT_DATE) 
  </code></pre>
  
  <p>Expected result for the above dataset will be as follows:</p>
  
  <pre><code>ID  EVENT_DATE       REOPEN_DATE
  4   15/1/2013 0:00  
  5   16/1/2013 16:36  16/1/2013 0:00
  2   16/1/2013 16:38 
  6   16/1/2013 17:12  16/1/2013 0:00
  11  4/8/2013 11:00  
  7   4/1/2014 9:00    4/1/2014 0:00
  9   4/1/2014 11:00  
  8   5/1/2014 14:00   5/1/2014 0:00
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>