How to retrieve two columns data in A,B format in Oracle

by

Tim Hall has a pretty canonical list of string aggregation techniques in Oracle.

Which technique you use depends on a number of factors including the version of Oracle and whether you are looking for a purely SQL solution. If you are using Oracle 11.2, I’d probably suggest using LISTAGG

SELECT column1, listagg( column2, ',' ) WITHIN GROUP( order by column2 )
  FROM table_name
 GROUP BY column1

If you are using an earlier version of Oracle, assuming you don’t need a purely SQL solution, I would generally prefer using the user-defined aggregate function approach.

More Related Contents:

  1. Is there a function to split a string in PL/SQL?
  2. how to convert csv to table in oracle
  3. Is there a function to split a string in Oracle PL/SQL?
  4. How to check if a string contains a substring in Bash
  5. Why does my string not match when reading user input from stdin?
  6. How to trim whitespace from a Bash variable?
  7. What’s the difference of strings within single or double quotes in groovy?
  8. Difference between text and varchar (character varying)
  9. Find string between two substrings [duplicate]
  10. Sqlite convert string to date
  11. How can I split multiple joined words?
  12. Call functions with special prefix/suffix
  13. Multiline strings in VB.NET
  14. Case insensitive comparison of strings in shell script
  15. null vs empty string in Oracle [duplicate]
  16. Cleanest way to build an SQL string in Java
  17. String compare in Perl with “eq” vs “==” [duplicate]
  18. Extract part of a string using bash/cut/split
  19. Why is capitalizing the first letter of a string so convoluted in Rust?
  20. How do you write multiline strings in Go?
  21. Algorithm to find articles with similar text
  22. Escape double quote in VB string
  23. Line continuation of strings in Fortran
  24. How to parse string to date in xslt 2.0
  25. Convert slice of string to slice of pointer to string
  26. Swift – Split string over multiple lines
  27. Groovy String to Date
  28. Efficiently repeat a character/string n times in Scala
  29. What is the difference between VBScript’s + and & operator?
  30. How do I find the last occurrence of a substring in a Swift string?

Leave a Comment