qq_36957648的博客

转载 ORALCE 单行转多行

WITH TESTTABLE AS ( SELECT 'TEST1' GROUPNAME , 'A,B,C,D,E' VALUENAME FROM DUAL UNION ALL SELECT 'TEST2' GROUPNAME , 'A,B,C,D' VALUENAME FROM DUAL ) SELECT GROUPNAME, ...