How to tweak LISTAGG to support more than 4000 character in select query?

by

You should add GetClobVal and also need to rtrim as it will return delimiter in the end of the results. 

SELECT RTRIM(XMLAGG(XMLELEMENT(E,colname,',').EXTRACT('//text()') 
  ORDER BY colname).GetClobVal(),',') from tablename;

More Related Contents:

  1. How do I convert between numeric types safely and idiomatically?
  2. Build a function object with properties in TypeScript
  3. TypeScript or JavaScript type casting
  4. Any difference between type assertions and the newer `as` operator in TypeScript?
  5. TypeScript: Index signature is missing in type
  6. Converting a Vec to Vec in-place and with minimal overhead
  7. CASTING attributes for Ordering on a Doctrine2 DQL Query
  8. Integer division: How do you produce a double?
  9. Multi-character constant warnings
  10. Cast List to List
  11. IO Error: The Network Adapter could not establish the connection
  12. Android: How can I Convert String to Date?
  13. What’s the difference between “as?”, “as!”, and “as”?
  14. Error on if statement – cannot implicitly convert type to ‘bool’
  15. Is the behaviour of casting a negative double to unsigned int defined in the C standard? Different behaviour on ARM vs. x86
  16. How to cast from List to double[] in Java?
  17. C# Cast Entire Array?
  18. Why does the Linq Cast helper not work with the implicit cast operator?
  19. C++ auto vs auto&
  20. Java: Casting from List to List when B implements A?
  21. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  22. Why is a SQL float different from a C# float
  23. What are the differences between asInstanceOf[T] and (o: T) in Scala?
  24. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  25. com.google.gson.internal.LinkedTreeMap cannot be cast to my class [duplicate]
  26. pow() cast to integer, unexpected result
  27. Is typecast required in malloc? [duplicate]
  28. Java: Long result = -1: cannot convert from int to long
  29. converting int to real in sqlite
  30. How can I extend a lexical cast to support enumerated types?

Leave a Comment