title: Oracle Rows to Column Transformation
body: <p>I have a table</p>
  
  <p><code>select * from table</code></p>
  
  <p>values returning are</p>
  
  <pre><code>login id | status_name | count
  ===============================
  admin    | open        |     3
  admin    | closed      |     5
  test     | inprogress  |    10
  test     | open        |    10
  test     | closed      |    11
  user1    | closed      |     5
  user1    | pending     |    10
  </code></pre>
  
  <p>how can i transfer this data from row to column?
  I want in this manner</p>
  
  <pre><code>login_id | open | closed | inprogress | pending
  ================================================
  admin    |    3 |      5 |          0 |       0
  test     |   10 |     10 |         10 |       0
  user1    |    0 |      5 |          0 |      10
  </code></pre>