title: view all data for duplicate rows in oracle
body: <p>I've got a table with 6 columns: </p>
  
  <ul>
  <li><code>id</code> </li>
  <li><code>name</code> </li>
  <li><code>type_id</code> </li>
  <li><code>code</code> </li>
  <li><code>lat</code> </li>
  <li><code>long</code></li>
  </ul>
  
  <p>The first three are required.  <code>ID</code> is the private key, inserted automatically with a sequence.</p>
  
  <p>I have some rows that are duplicates, as defined by BOTH the <code>name</code> and <code>type_id</code> being equal, but i'd like to view all the data for the dupes.  I can find the dupes simply enough:</p>
  
  <pre><code>SELECT   name 
         , type_id
  FROM   table1
  GROUP BY name 
           , type_id
  HAVING COUNT(*) &gt; 1
  </code></pre>
  
  <p>but actually viewing all the info is confounding me.  I know this should be simple, but I'm hitting a wall here.</p>