Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]

by

(WARNING – WM_CONCAT is an unsupported function that was removed in version 12c. Unless you’re using a very old database, you should avoid this function. You should probably use LISTAGG instead.)

It depends on the version of Oracle you’re using. If it supports the wm_concat() function, then you can simply do something like this:

SELECT field1, wm_concat(field2) FROM YourTable GROUP BY field2;

wm_concat() basically works just like group_concat() in MySQL. It may not be documented, so fire up ye olde sqlplus and see if it’s there.

If it isn’t there, then you’ll want to implement something equivalent yourself. You can find some instructions on how to do this in the string aggregation page at oracle-base.com.

More Related Contents:

  1. What is the string concatenation operator in Oracle?
  2. How do I limit the number of rows returned by an Oracle query after ordering?
  3. How to create id with AUTO_INCREMENT on Oracle?
  4. When do I need to use a semicolon vs a slash in Oracle SQL?
  5. LISTAGG in Oracle to return distinct values
  6. Using ‘case expression column’ in where clause
  7. Oracle SQL escape character (for a ‘&’)
  8. Convert a string date into datetime in Oracle
  9. DATEDIFF function in Oracle [duplicate]
  10. WHERE IN condition not accepting String value
  11. What is the difference between Views and Materialized Views in Oracle?
  12. Pivoting of data using two columns
  13. Benefits Of Using SQL Ordinal Position Notation?
  14. ORA-00907: missing right parenthesis
  15. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  16. Foreign Key Creation issue in Oracle
  17. Custom Order in Oracle SQL
  18. How do I list all tables in a schema in Oracle SQL?
  19. Is there a version control system for database structure changes?
  20. oracle sql: update if exists else insert [duplicate]
  21. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  22. Compare Strings ignoring accents in SQL (ORACLE)
  23. Return number from Oracle Select statement after parsing date
  24. How do you interpret a query’s explain plan?
  25. Oracle DB: How can I write query ignoring case?
  26. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  27. How to call Oracle MD5 hash function?
  28. Oracle Convert TIMESTAMP with Timezone to DATE
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment