title: How to get the duplicate names of employees who have multiple employee numbers
body: <p>I'm using Oracle 10g.</p>
  
  <p>If i have the following duplicate rows (<strong>Same Employee with two Employee numbers</strong>):</p>
  
  <pre><code>Employee_No      Employee_Name      ID_NO
  ----------------------------------------------
  0002345          John Debb          100345642
  0030988          John Debb          100345642
  ----------------------------------------------
  </code></pre>
  
  <p>i want to get the result as:</p>
  
  <pre><code>Employee_No_1      Employee_No_2     Employee Name    ID_NO
  ----------------------------------------------------------------
  0002345            0030988           John Debb        100345642
  ----------------------------------------------------------------
  </code></pre>
  
  <p><strong>Is it possible to be done in SQL? or it needs PL/SQL? and what would the query be?</strong></p>