Warning: Table '.\dcgforum\cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://forums.dataphor.org/index.php?q=node/43' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
Mapping Concat | Dataphor Forums

Mapping Concat

Oracle 11.2 has added the listagg aggregate function, which does the same job as Concat:

T group by { A } add { Concat(B, C order by { A, B }) Bs }
=>
select A, listagg(B, C) within group (order by B) as Bs from T group by A

But how can I create a device mapping for it that includes the ordering?


Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: LOCK TABLES cache_page WRITE</em> in <em>C:\\Sites\\DCGForum\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://forums.dataphor.org/index.php?q=node/43', '', '54.196.190.32', 1542386098) in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &amp;#039;\\0\\0\\0\\0\\0\\0Xn6?@aE Dflhꚤk kf؆hRJRqܭ@b/=NdGeN6,SxS&amp;amp;O^ d6ꗣ@JSzrv=;{q\\nZD\\&amp;#039;?[;\\0$&amp;lt;t&amp;gt;)=^:EC/6&amp;amp;᭝7tL7h&amp;gt;|^HЁdE:% ЍBg|q/XY\\&amp;quot;cUD_p,+3GLh-,ʹeJ\\\\L ٢nJ,9tQƴvZ$x@;)wlTY@y2%42 phgJDRN/zDy,ؔ0)IK4*B_NpBk&amp;lt;1OX%AM( rz\\&amp;quot;[TڌK *E_\\rHI[hA7{Y;4뭔Z\\Z&amp;amp;o &amp;gt; in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Incorrect string value: &amp;#039;\\x8B\\x08\\0\\0...&amp;#039; for column &amp;#039;session&amp;#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;0pif10duj4aq79frblfgu4b484&amp;#039;, 0, 0, &amp;#039;54.196.190.32&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:195:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is marked as crashed and should be repaired\\nquery: LOCK TABLES cache_page WRITE in C:\\\\Sites\\\\DCGForum\\\\includes\\\\database.mysql.inc on line 172.\\&amp;quot;;i:1;s:2096:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is mark in C:\Sites\DCGForum\includes\database.mysql.inc on line 172