salvis_favicon_fullsalvis_favicon_fullsalvis_favicon_fullsalvis_favicon_full
  • Home
  • Archive
  • Download
  • Talks
  • Contact
  • About
✕
  • Filter by
  • Categories
  • Tags
  • Authors
  • Show all
  • All
  • Apple
  • Common
  • Oracle
  • Symbian
  • All
  • accessible_by_clause
  • Arbori
  • Autonomous Database
  • Code Analysis
  • CSV
  • Debugging
  • Decision Time
  • Docker
  • Flashback
  • Flashback Data Archive
  • GraalVM
  • Java
  • JavaScript
  • JDBC
  • Jenkins
  • JOOQ
  • JSON
  • oddgen
  • Performance
  • PinkDB
  • PL/Scope
  • PL/SQL
  • PL/SQL Analyzer
  • PL/SQL Cop
  • PL/SQL Unwrapper
  • Psion
  • RegEx
  • SmartDB
  • Snowflake
  • SonarQube
  • SQL
  • SQL Developer
  • SQL Injection
  • SQLcl
  • Temporal Database
  • Transaction Time
  • utPLSQL
  • Valid Time
  • WFH
  • All
  • Philipp Salvisberg
2012-12-23
blank
2012-12-23
Categories
  • Oracle

Building Comma Separated Values with Oracle & SQL

From time to time I’m asked to aggregate strings from multiple records into a single column using SQL. Here’s an example, showing a comma separated list of ordered employee names per department based on the famous EMP and DEPT tables. Oracle introduced the aggregate function LISTAGG for that purpose in 11.2. If […]
Do you like it?
2 Read more
Copyright © 2023 Philipp Salvisberg.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.