String Aggregation Techniques in Oracle ListAgg - Details, Limitations, and Alternatives

Cristian Dumitrescu ()
Additional contact information
Cristian Dumitrescu: IBM Romania

Database Systems Journal, 2021, vol. 12, issue 1, 32-39

Abstract: This paper proposes several ways to overcome the ORA-01489 result of string concatenation is too long error in early versions of Oracle Database (before 12c). Each proposed alternative is presented with pros and cons and may be applied only in specific cases, depending on the requirement or cause.

Keywords: Relational Databases; Oracle; ListAgg; ORA-01489; User-Defined Functions (search for similar items in EconPapers)
Date: 2021
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://dbjournal.ro/archive/32/32_4.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:12:y:2021:i:1:p:32-39

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().