We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [listagg]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
3answers
247 views

De-Duplicate from LISTAGG

I am using 11.2 version of oracle. I want to de-duplicate from LISTAGG. below is existing data in oracle db: Speaker | Qualification | Product P A P1 P B ...
0
votes
1answer
105 views

listagg in order and including a sequence of separator when missing any row of a sequence

Sorry for the long title but it's a little bit difficult to explain. We have a table | N rows | Atrib1 | Atrib2 | Atrib3 | Atrib4 | Final row | --------------------------------------------------...
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
1answer
251 views

Concatenate Data from different row from same table

This is SQL source Table. I need to concatenate this table like the table below,appreciate your help. PE_CASE PE_ITEM PE_HIS_SEQ PE_COMMENT 200 0001 9989 Comment 1 200 ...