How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]

by

The WM_CONCAT function (if included in your database, pre Oracle 11.2) or LISTAGG (starting Oracle 11.2) should do the trick nicely. For example, this gets a comma-delimited list of the table names in your schema:

select listagg(table_name, ', ') within group (order by table_name) 
  from user_tables;

or

select wm_concat(table_name) 
  from user_tables;

More details/options

Link to documentation

More Related Contents:

  1. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  2. Dynamic Pivot in Oracle’s SQL
  3. SQL Query to concatenate column values from multiple rows in Oracle
  4. Oracle SQL pivot query
  5. Oracle SQL, concatenate multiple columns + add text
  6. Pivoting rows into columns dynamically in Oracle
  7. Concatenate and group multiple rows in Oracle [duplicate]
  8. Concatenate results from a SQL query in Oracle
  9. Dynamic Oracle Pivot_In_Clause
  10. Using pivot on multiple columns of an Oracle row
  11. Oracle Dynamic Pivoting
  12. How to convert Rows to Columns in Oracle? [duplicate]
  13. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  14. Advice Using Pivot Table in Oracle
  15. Why does the wm_concat not work here?
  16. Oracle string aggregation
  17. How do I use variables in Oracle SQL Developer?
  18. SQL Server : dynamic pivot over 5 columns
  19. How to Select a substring in Oracle SQL up to a specific character?
  20. passing table and column name dynamically using bind variables
  21. Conditional SUM on Oracle
  22. ORA 00904 Error:Invalid Identifier
  23. Nth max salary in Oracle
  24. String concatenation does not work in SQLite
  25. What does the colon sign “:” do in a SQL query?
  26. Inserting into Oracle and retrieving the generated sequence ID
  27. How to insert a string which contains an “&”
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. Why are aggregate functions not allowed in where clause
  30. Insert into from CTE

Leave a Comment