DEV Community

Loïc
Loïc

Posted on

Smart list of values in SQL with LISTAGG

#database #sql #programming

LISTAGG

👉LISTAGG(): aggregates the values of a column by concatenating them into one string. Adding overflow management for a very long list of values.😀😀😁😁😁😂😂😅😅🤣🤣🤣🤣😱💥💨

Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/LISTAGG.html#GUID-B6E50D8E-F467-425B-9436-F7F8BF38D466

Gist: https://gist.github.com/loiclefevre/1ae2e9f496e0156277feeff1b6e03242

Top comments (0)

Read next

mdarifulhaque profile image

2924. Find Champion II

MD ARIFUL HAQUE -

guillaumesere profile image

Sortie de TypeScript 5.7 RC, nouvelle alternative à npm, avenir des frameworks JavaScript - Cette semaine en JS

Guillaume Sere -

saurabh-dhariwal profile image

Building WordPress APIs: Connecting IoT Devices to Your Site

Saurabh Dhariwal -

zirkelc profile image

Buffer Logs and Flush Automatically on Error with Powertools for Lambda

Chris Cook -