2

Hi i am looking for a function same group_concat of mysql in oracle or some functionality

maxjackie
  • 22,386
  • 6
  • 29
  • 37
  • Google ftw: http://halisway.blogspot.com/2006/08/oracle-groupconcat-updated-again.html – dborba Jul 14 '09 at 18:57
  • http://stackoverflow.com/questions/1120706/is-there-an-oracle-sql-query-that-aggregates-multiple-rows-into-one-row – derobert Feb 03 '11 at 21:38

2 Answers2

7

You can use Tom Kyte's STRAGG function

Tony Andrews
  • 129,880
  • 21
  • 220
  • 259
0

You can use Oracle wm_concat() function

Primal Suaris
  • 1