Details
-
Type:
Technical task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: XML Functions
-
Labels:
Description
Most oracle applications use xml aggregation functions like XMLAGG() followed by identifying the XML elements XMLELEMENT() and then calling the EXTRACT() method to extract. This is important for Oracle migrations and is in use by many projects which are using XML in Oracle and are trying to Migrate to MariaDB.
select
|
deptno,
|
rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames |
from
|
emp
|
group by |
deptno
|
;
|
 |
DEPTNO ENAMES
|
---------- ----------------------------------------
|
10 CLARK,MILLER,KING
|
20 SMITH,FORD,ADAMS,SCOTT,JONES
|
30 ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD
|
Reference: http://www.dba-oracle.com/t_xmlagg.htm