title: Find overlapping data in a list
body: <p>I am trying to find some overlapping data in this list.</p>
  
  <p>I do not have a way to group this.</p>
  
  <p>How can I get the results as shown below?</p>
  
  <p>Data in table:</p>
  
  <pre><code>PLAN_MIN    PLAN_MAX
  220554          229079
  220554          229079 
  2210A5          2210A5 
  2210A8          2210A8 
  2220A5          2220A5 
  2220A8          2220A8 
  2230A5          2230A5 
  2230A8          2230A8 
  260554          267566 
  2610A5          2610A5 
  2610A8          2610A8 
  2620A5          2620A5 
  2620A8          2620A8
  </code></pre>
  
  <p><em>Results:</em></p>
  
  <pre><code>PLAN_MIN    PLAN_MAX    PLAN_MIN_1  PLAN_MAX_1
  2210A5          2210A5          220554          229079
  2210A8          2210A8          220554          229079
  2220A5          2220A5          220554          229079
  2220A8          2220A8          220554          229079
  2230A5          2230A5          220554          229079
  2230A8          2230A8          220554          229079      
  2610A5          2610A5          260554          267566
  2610A8          2610A8          260554          267566
  2620A5          2620A5          260554          267566
  2620A8          2620A8          260554          267566
  
  
  create table plan_details
  (PLAN_MIN   varchar2(20)
  ,PLAN_MAX   varchar2(20)
  );
  insert into plan_details values ('220554','229079' );
  insert into plan_details values ('2210A5','2210A5' );
  insert into plan_details values ('2210A8','2210A8' );
  insert into plan_details values ('2220A5','2220A5' );
  insert into plan_details values ('2220A8','2220A8' );
  insert into plan_details values ('2230A5','2230A5' );
  insert into plan_details values ('2230A8','2230A8' );
  insert into plan_details values ('260554','267566' );           
  insert into plan_details values ('2610A5','2610A5' );
  insert into plan_details values ('2610A8','2610A8' );
  insert into plan_details values ('2620A5','2620A5' );
  insert into plan_details values ('2620A8','2620A8' );
  commit;
  </code></pre>