Advertisement
llun012

Oracle: Group value concat

Aug 9th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.21 KB | None | 0 0
  1. SELECT
  2.     GROUP_COLUMN "GROUPER",
  3.     LISTAGG (CONCAT_COLUMN, ', ') WITHIN GROUP (ORDER BY ORDER_COLUMN1, ORDER_COLUMN2) "VALUES"
  4. FROM
  5.     TABLE
  6. WHERE
  7.     /* Filter condition */
  8. GROUP BY
  9.     /* Order field */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement