Questions tagged [listagg]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
124 views

Better ways to remove duplicate values of columns when using pl-sql "listagg" function in oracle

I have a table as you can see below : c_id | Name1 | Name2 | Name3 -------------------------------- 1 | a | b | c 1 | c | d | a 2 | d | e | a 2 |...
2
votes
0answers
4k views

"result of string concatenation is too long"

I have a query which uses listagg it is as follows SELECT listagg(path1.PATHWAY_ID,'|like||id|')within GROUP ( ORDER BY path1.PATHWAY_ID), listagg(path1.PATHWAY_NAME,'|like||name|') within GROUP ( ...
0
votes
0answers
108 views

How to use PIVOT or LISTAGG to solve this?

I have a table like below. USERID USERNAME ITEM 12345 JESSE ITEM1 12345 JESSE ITEM3 12345 DON ITEM2 12346 DANNY ITEM4 12346 ELISA ITEM1 12347 ANDY ITEM2 12347 ANDY ITEM4 What im trying to ...
0
votes
0answers
717 views

Remove/distinct duplicates on listagg - oracle

I'm using the oracle-xe 11g version and I have the below sql code that I aggregation the course code, but the output has duplicates. SELECT b.alu_cpf AS login, b.alu_nomeco ...
0
votes
0answers
824 views

Removing Duplicates in LISTAGG

In the query below, I used the LISTAGG function to aggregate certificate names I.e. JPM_DESCR90 . However , now I'm trying to find a way to remove all the duplications in the row, and reducing the ...