我有以下查询
SELECT 1, 2 FROM DUAL
AND I'd like something like
SELECT TRANSPOSE(SELECT 1, 2 FROM DUAL)
这将输出与以下内容相同
SELECT 1 FROM DUAL
UNION
SELECT 2 FROM DUAL
我希望它可以将行和列交换。
select no from
(SELECT 1 a, 2 b FROM DUAL) dummy
unpivot (no for col in (a as 'A', b as 'B'))
dbms_xmlgen.getxmltype
和 XMLTABLE
:SELECT *
FROM XMLTABLE('/ROWSET/ROW/*' passing dbms_xmlgen.getxmltype('SELECT 1, 2, 3 FROM DUAL')
COLUMNS val VARCHAR(100) PATH '.');
与 unpivot 相比的优势 - 无需提前指定列列表
SELECT 1 FROM DUAL
UNION
SELECT 2 FROM DUAL