title: Group rows in Oracle using PARTITION BY
body: <p>I have below 2 tables which i want to display like shown result</p>
  
  <p>Data Table 1</p>
  
  <pre><code>id    col1      col2
  t1    data1     data2
  t2    data3     data4  
  </code></pre>
  
  <p>Data Table 2</p>
  
  <pre><code>idOfTable1   col3       col4
  t1           data5      data6
  t1           data7      data8
  t1           data9      data10    
  t2           data11     data12
  </code></pre>
  
  <p>Expected result 
  Want to display the id value in first row only for the common rows
  Result DataTable after Join of 2 tables on id column
  How can i achieve in Oracle</p>
  
  <pre><code>idofTable1      col1       col2       col3        col4
  t1              data1      data2      data5       data6
                                        data7       data8
                                        data9       data10
  t2              data3      data4      data11      data12
  </code></pre>