LISTAGG function: “result of string concatenation is too long”

by 
SELECT RTRIM(XMLAGG(XMLELEMENT(E,colname,',').EXTRACT('//text()') ORDER BY colname).GetClobVal(),',') AS LIST
FROM tablename;

This will return a clob value, so no limit on rows.

More Related Contents:

  1. How to create id with AUTO_INCREMENT on Oracle?
  2. When do I need to use a semicolon vs a slash in Oracle SQL?
  3. LISTAGG in Oracle to return distinct values
  4. SQL Error: ORA-00933: SQL command not properly ended
  5. CASE vs. DECODE
  6. DATEDIFF function in Oracle [duplicate]
  7. WHERE IN condition not accepting String value
  8. What is the difference between Views and Materialized Views in Oracle?
  9. Pivoting of data using two columns
  10. Check if current date is between two dates Oracle SQL
  11. ORA-00907: missing right parenthesis
  12. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  13. Unordered results in SQL
  14. Oracle Dynamic Pivoting
  15. Foreign Key Creation issue in Oracle
  16. create custom function for date difference excluding weekends and holidays in oracle sql
  17. What is it exactly a BLOB in a DBMS context
  18. Custom Order 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