oracle sql拆分合并字符串

oracle拆分字符串到多行

SELECT
	REGEXP_SUBSTR( 'a,b', '[^,]+', 1, LEVEL ) COLS 
FROM
	DUAL CONNECT BY REGEXP_SUBSTR( 'a,b', '[^,]+', 1, LEVEL ) IS NOT NULL

oracle合并两列到一列

例如
a d
b e
c f
变成
a
b
c
d
e
f

SELECT A from T UNION ALL SELECT B from T