2

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

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
maxjackie
  • 20,978
  • 5
  • 27
  • 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
  • 126,319
  • 20
  • 218
  • 255
0

You can use Oracle wm_concat() function

Primal Suaris
  • 1