title: ORACLE SQL listagg function
body: <p>I'm not sure what's going on here, mostly because I've never used this function, but when I use the listagg function on our Oracle 11g database it gives me an ORA-00923 FROM keyword not found where expected.</p>
  
  <p>Here's my SQL</p>
  
  <pre><code>SELECT  cdm.courses_id,cde.additional_resources, listagg (dm.delivery_method_desc, ',')
  WITHIN GROUP (ORDER BY dm.delivery_method_desc) delivery_methods
  FROM    tablespace.course_de_delivery_methods cdm,
        tablespace.course_distance_ed cde,
        tablespace.delivery_methods dm
  WHERE   cdm.courses_id = cde.courses_id
  AND   cdm.delivery_methods_id = dm.delivery_methods_id
  GROUP BY cdm.courses_id
  </code></pre>
  
  <p>I haven't a clue why this is breaking.  I was following the example found <a href="http://www.dba-oracle.com/t_display_multiple_column_values_same_rows.htm" rel="noreferrer">here.</a></p>