title: Oracle SQL - Multiple rows into one field
body: <p>I have a table like this:</p>
  
  <p><a href="https://i.stack.imgur.com/xGntp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xGntp.png" alt="enter image description here"></a></p>
  
  <p>I need a query (no PL/SQL) that shows this output:</p>
  
  <p><a href="https://i.stack.imgur.com/af2ff.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/af2ff.png" alt="enter image description here"></a></p>
  
  <p>So for each <strong>Product ID</strong> I want the distinct values of <strong>Delivery Type</strong> in the field <strong>Delivery Type</strong>.</p>
  
  <p>Is there a way to get this result through a "simple" query in Oracle?</p>
  
  <p>I am using Oracle 11g.</p>
  
  <p>Thanks in advance !</p>