title: how to get the values from table which contains key value pair structure in oracle
body: <p>I have a table with the below structure  i want to get the name and address values based on id value. </p>
  
  <p>i tried with below  query but it didn't work.</p>
  
  <pre><code>select name,address from details where c_id=111
  table name=**details**
  
  c_id   key    value
  111    name   abc
  111    email  add@gmail.com
  111    address  h.no 22,hyderabad
  222    name    raj
  222    email   xyz@yahoo.com
  222    address h.no 24,india
  </code></pre>