title: Oracle : How to make pivot query?
body: <p>I have a table like this :</p>
  <p><strong>Table1:</strong>
  <strong>ID</strong> number, <strong>Product</strong> varchar2, <strong>Argument</strong> varchar2, <strong>Value</strong> AnyData</p>
  <p>When it's filled, it looks like this :</p>
  <p><a href="https://i.stack.imgur.com/f0hii.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/f0hii.png" alt="enter image description here" /></a></p>
  <p>I would like to create a view such as the result is :</p>
  <p><a href="https://i.stack.imgur.com/5yXrF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5yXrF.png" alt="enter image description here" /></a></p>
  <p>I tried the following query :</p>
  <pre><code>select * from 
  (select ARGUMENT, VALUE from Table)
  pivot 
  (first(VALUE) for ARGUMENT in ('Weight','Size','First Use'))
  </code></pre>
  <p>I tried with both aggregating functions : First and Max.</p>
  <p>For both of them I get the following errors :</p>
  <ul>
  <li>ORA-56902: expect aggregate function inside pivot operation.</li>
  <li>ORA-22950: cannot ORDER objects without MAP or ORDER method.</li>
  </ul>
  <p>I do Understand both of these errors. The pivot query can work like this.</p>
  <p>But does anyone know another way to achieve the required result please ?</p>
  <p>Thanks.
  Cheers,</p>