tag:blogger.com,1999:blog-13668718.post115471055787389948..comments2023-10-30T12:24:51.923+00:00Comments on Halis way: Oracle group_concat() updated (again)Hampushttp://www.blogger.com/profile/12826832242493809239noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-13668718.post-77992181163234589582018-06-14T21:51:18.284+01:002018-06-14T21:51:18.284+01:00Youre so cool! I dont suppose Ive read anything li...Youre so cool! I dont suppose Ive read anything like this before. So nice to find somebody with some authentic ideas on this subject. realy thanks for beginning this up. this website is one thing that is needed on the internet, somebody with a little bit originality. useful job for bringing something new to the internet! <a href="https://casinorealmoney2018.us.org" rel="nofollow">online casino</a>fillikir72518https://www.blogger.com/profile/04617626994297367122noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-7268449234787057992015-08-18T09:46:28.129+01:002015-08-18T09:46:28.129+01:00This is also a very good post which I really enjoy...This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something<br /><a href="http://www.kidsgamesonline.net/" rel="nofollow">kids games online</a><br /><a href="http://www.friv2friv22.com/" rel="nofollow">friv 2</a><br /><a href="http://www.unblocked-games-77.com/" rel="nofollow">unblocked games</a><br /><a href="http://www.juegosdeunshowmasgratis.com/" rel="nofollow">juegos de un show mas</a><br />Anonymoushttps://www.blogger.com/profile/00123816553128203525noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-66652963986677996562015-08-18T09:07:16.772+01:002015-08-18T09:07:16.772+01:00What a great online source of information about th...What a great online source of information about this topic. you have done great work. keep continue to sharing such kinds of post. keep it up.<br /><a href="http://www.juegosjuegosgames.com/" rel="nofollow">juegosjuegos.com</a><br /><a href="http://www.juegosdematarzombiesgratis.com/" rel="nofollow">juegos de matar zombies</a><br /><a href="http://www.jogosdofrivonline.net/" rel="nofollow">jogos do friv</a><br />Anonymoushttps://www.blogger.com/profile/11060633445047647548noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-72215783698170669352013-07-31T13:52:23.373+01:002013-07-31T13:52:23.373+01:00Thanx very much!!!Thanx very much!!!Anonymoushttps://www.blogger.com/profile/16455887641143600773noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-88551989260332147032011-12-20T14:27:20.557+00:002011-12-20T14:27:20.557+00:00I enjoy so much this kind of articles because I ca...I enjoy so much this kind of articles because I can put it on practice and learn<br /><a href="http://www.smartonlinepharmacy.com" rel="nofollow">Generic Viagra</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13668718.post-15825360446306901942011-11-24T15:30:01.331+00:002011-11-24T15:30:01.331+00:00I found a nice article in this page below:
http:...I found a nice article in this page below: <br /><br />http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php<br /><br />I hope this help you.Eric Silvahttps://www.blogger.com/profile/04779858700433358818noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-55225445929713479802011-11-24T15:29:47.814+00:002011-11-24T15:29:47.814+00:00This comment has been removed by the author.Eric Silvahttps://www.blogger.com/profile/04779858700433358818noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-29841431923987143712011-05-20T00:53:14.196+01:002011-05-20T00:53:14.196+01:00Actually wm_concat is an undocumented function. I ...Actually wm_concat is an undocumented function. I guess it would be better to use listagg.<br />http://download.oracle.com/docs/cd/E14072_01/server.112/e10592/functions087.htmRavi Sanwalhttps://www.blogger.com/profile/14301532697780866786noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-65013675461028761162009-11-24T10:51:09.922+00:002009-11-24T10:51:09.922+00:00select job,wmsys.wm_concat(ename) from scott.emp g...select job,wmsys.wm_concat(ename) from scott.emp group by jobHare Krishnahttps://www.blogger.com/profile/12905746422238555087noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-61195579247401132322009-11-24T10:48:32.757+00:002009-11-24T10:48:32.757+00:00in 10 g we can use wmsys.wm_concat function for th...in 10 g we can use wmsys.wm_concat function for thisHare Krishnahttps://www.blogger.com/profile/12905746422238555087noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-17069519416385464172009-10-28T19:02:07.616+00:002009-10-28T19:02:07.616+00:00This post would be much more useful if you shared ...This post would be much more useful if you shared with us the table structure being used.Fireproofhttps://www.blogger.com/profile/02540425544203737040noreply@blogger.comtag:blogger.com,1999:blog-13668718.post-79853486837961739542007-07-24T19:10:00.000+01:002007-07-24T19:10:00.000+01:00This can also be done in a similar way using the M...This can also be done in a similar way using the MODEL clause (available in Oracle 10g or greater). In this example, I'm concatenating without any separator. The update rule in the model can easily be changed accordingly.<BR/><BR/>with data as<BR/>(<BR/> select job, ename,<BR/> row_number() over (partition by job order by ename) rn,<BR/> count(*) over (partition by job) cnt<BR/> from emp<BR/>)<BR/>select job, scbp<BR/>from (<BR/> select job, scbp, rn, cnt<BR/> from data<BR/> model<BR/> partition by (job)<BR/> dimension by (rn)<BR/> measures (ename, cnt, cast(null as varchar2(50)) scbp)<BR/> (<BR/> scbp[any] = scbp[cv()-1] || ename[cv()]<BR/> )<BR/>)<BR/>where rn = cnt<BR/>order by job<BR/>/<BR/>JOB SCBP<BR/>--------- --------------------------------------------------<BR/>ANALYST FORDSCOTT<BR/>CLERK ADAMSJAMESMILLERSMITH<BR/>MANAGER BLAKECLARKJONES<BR/>PRESIDENT KING<BR/>SALESMAN ALLENMARTINTURNERWARDAnonymousnoreply@blogger.com