LISTAGG does not work in Oracle Cloud

Question

I am trying to run the query below select organization_id , listagg(secondary_inventory_name, ',') within group(order by secondary_inventory_name) as the_list from inv_secondary_inventories group by organization_id , but it keeps giving this error: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected What do I do wrong? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

select organization_id , listagg(secondary_inventory_name, ',') within group(order by secondary_inventory_name) as the_list from inv_secondary_inventories group by organization_id The above is your query. Just keep the listagg statement in brackets and that would do magic.. select organization_id ,( listagg(secondary_inventory_name, ',') within group(order by secondary_inventory_name) )as the_list from inv_secondary_inventories group by organization_id