How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]

by

From Oracle 11gR2, the LISTAGG clause should do the trick:

SELECT question_id,
       LISTAGG(element_id, ',') WITHIN GROUP (ORDER BY element_id)
FROM YOUR_TABLE
GROUP BY question_id;

Beware if the resulting string is too big (more than 4000 chars for a VARCHAR2, for instance): from version 12cR2, we can use ON OVERFLOW TRUNCATE/ERROR to deal with this issue.

More Related Contents:

  1. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  2. SQL Query to concatenate column values from multiple rows in Oracle
  3. Oracle SQL, concatenate multiple columns + add text
  4. Concatenate and group multiple rows in Oracle [duplicate]
  5. Concatenate results from a SQL query in Oracle
  6. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  7. Why does the wm_concat not work here?
  8. Oracle string aggregation
  9. Receive an unexpected symbol error in my PLSQL query [closed]
  10. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  11. Select First Row of Every Group in sql [duplicate]
  12. Paging with Oracle
  13. Comparing Dates in Oracle SQL
  14. Oracle Differences between NVL and Coalesce
  15. SQL – How to store and navigate hierarchies?
  16. GROUP BY / aggregate function confusion in SQL
  17. Calculating difference between two timestamps in Oracle in milliseconds
  18. How to concatenate columns in a Postgres SELECT?
  19. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  20. SQL Error: ORA-01861: literal does not match format string 01861
  21. Determine Oracle null == null
  22. How to anticipate and escape single quote ‘ in oracle
  23. Oracle insert if row does not exist
  24. SELECT INTO using Oracle
  25. `show create table` equivalent in oracle sql
  26. Query json dictionary data in SQL
  27. ORA-00972 identifier is too long alias column name
  28. ORA-00933: SQL command not properly ended
  29. Update a table with data from another table
  30. Insert into from CTE

Leave a Comment