Skip to Main Content
Question

How to use LISTAGG?

0
Votes

288
Views
I want to concatenate values in Oracle
oracle sql
Asked 24 Feb 2026
Abdullah Al Mamun

9 Answers

✔ Vote Up/Down system per answer ✔ Accepted Answer (Green Highlight) ✔ Edit/Delete button (only owner) ✔ Rich text answer editor
2
Abdullah Al Mamun 24 Feb 2026
India
2
Abdullah Al Mamun 24 Feb 2026
LISTAGG is a function in Oracle that combines multiple rows into a single string. It is used with WITHIN GROUP and ORDER BY. It is helpful for showing comma-separated values, tag lists, or combined text from multiple rows.
-1
Abdullah Al Mamun 24 Feb 2026
Okey
-2
Abdullah Al Mamun 26 Feb 2026
abc ef
2
Abdullah Al Mamun 27 Feb 2026
test
1
Abdullah Al Mamun 28 Feb 2026
abc
0
Abdullah Al Mamun 28 Feb 2026
test
1
Abdullah Al Mamun 28 Feb 2026
test
0
Abdullah Al Mamun 28 Feb 2026

Join the conversation

Log in to vote for helpful answers or share your own knowledge.

Login to Answer