SELECT '殘疾人|民政|綜合治理|計劃生育|物業監管|安全生產|環境類|司法信訪|黨建|社會組織|文化體育|社保' D , 
'53|52|51|50|49|48|47|5|4|3|2|1' g FROM dual

SELECT * FROM (
SELECT REGEXP_SUBSTR(E.D, '[^|]+',1, ROWNUM) BRAND , REGEXP_SUBSTR(E.g, '[^|]+',1, ROWNUM) BRAND1 FROM
(SELECT '殘疾人|民政|綜合治理|計劃生育|物業監管|安全生產|環境類|司法信訪|黨建|社會組織|文化體育|社保' D , 
'53|52|51|50|49|48|47|5|4|3|2|1' g FROM dual)E
CONNECT BY ROWNUM <= "LENGTH"("REGEXP_REPLACE"(E.D, '|', ''))
)WHERE BRAND IS NOT NULL AND BRAND1 IS NOT NULL