SQL Query to concatenate column values from multiple rows in Oracle

by

There are a few ways depending on what version you have – see the oracle documentation on string aggregation techniques. A very common one is to use LISTAGG:

SELECT pid, LISTAGG(Desc, ' ') WITHIN GROUP (ORDER BY seq) AS description
FROM B GROUP BY pid;

Then join to A to pick out the pids you want.

Note: Out of the box, LISTAGG only works correctly with VARCHAR2 columns.

More Related Contents:

  1. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  2. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  3. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  4. Why does the wm_concat not work here?
  5. Oracle string aggregation
  6. SQL Query output in VBA is different than in SQL Oracle
  7. I want to find out how much zero come after 1 in SQL
  8. Best way to do multi-row insert in Oracle?
  9. Why does Oracle 9i treat an empty string as NULL?
  10. How do I reset a sequence in Oracle?
  11. LISTAGG function: “result of string concatenation is too long”
  12. ORA-00904: invalid identifier
  13. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  14. How do I use variables in Oracle SQL Developer?
  15. How to use Oracle ORDER BY and ROWNUM correctly?
  16. How can I create a copy of an Oracle table without copying the data?
  17. How to get second largest or third largest entry from a table [duplicate]
  18. Split String by delimiter position using oracle SQL
  19. ORA 00904 Error:Invalid Identifier
  20. Update with Join query in Oracle
  21. What does the colon sign “:” do in a SQL query?
  22. Autoincrement in oracle to already created table
  23. SQL not displaying null values on a not equals query?
  24. What can cause an Oracle ROWID to change?
  25. How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement
  26. Oracle query to match all values in the list among all rows in table
  27. Inserting into Oracle and retrieving the generated sequence ID
  28. How to check if a column exists before adding it to an existing table in PL/SQL?
  29. How can I solve ORA-00911: invalid character error?
  30. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?

Leave a Comment