SELECT xmlelement("root",xmlagg(xmlforest(xmlforest(
字段1,字段2,字段3,字段4 ...
)TBL))).getclobval()
from table
where 条件
转载于:https://www.cnblogs.com/scbaoma2008/archive/2012/11/02/2751266.html
SELECT xmlelement("root",xmlagg(xmlforest(xmlforest(
字段1,字段2,字段3,字段4 ...
)TBL))).getclobval()
from table
where 条件
转载于:https://www.cnblogs.com/scbaoma2008/archive/2012/11/02/2751266.html