tag:blogger.com,1999:blog-697307722356110163.post7762664134267991868..comments2023-10-19T08:14:15.629-04:00Comments on Halimdba: How to collect values from multiple rows into a single, comma delimited string (using vm_concat ,stragg)halimdbahttp://www.blogger.com/profile/06064045814557676169noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-697307722356110163.post-69235166358766499102012-02-01T06:50:13.797-05:002012-02-01T06:50:13.797-05:00Nice Tips Halim Bhai
Thanks
A S M RusselNice Tips Halim Bhai<br />Thanks<br />A S M RusselAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-27215736583714215982011-04-20T07:43:44.690-04:002011-04-20T07:43:44.690-04:00Hi,
Can you please tell me the basic difference b...Hi, <br />Can you please tell me the basic difference between the use of - wm_concat and RTRIM(XMLAGG (XMLELEMENT ()))<br />I had a query which returned 14000+ records.<br />When i used wm_concat, the query took 3 secs.<br />But when i used RTRIM(XMLAGG (XMLELEMENT ())), the query took more than 2 minutes.Anonymousnoreply@blogger.com