WITH tmp (f1, f2) AS (VALUES ('a', 1), ('b', 2), ('c', 3))
SELECT SUBSTR (
XMLSERIALIZE (
XMLAGG (XMLTEXT (f1 || ',') ORDER BY f2) AS CLOB (1 M)),
1,
50)
AS pivot_f1
FROM tmp
UNION ALL
SELECT SUBSTR (
XMLSERIALIZE (
XMLAGG (XMLTEXT (f2 || ',') ORDER BY f2) AS CLOB (1 M)),
1,
50)
FROM tmp
系统集成 · 2013-06-20