oracle中如何根据count数，循环出记录数

Question

WITH T(A,COUNT1) AS(
SELECT 'A', 2 FROM DUAL UNION ALL
SELECT 'B', 3 FROM DUAL UNION ALL
SELECT 'C', 2 FROM DUAL
)
需要根据A，B，C的count数，查询出如下格式的记录
A
A
B
B
B
C
C
，如何用sql查询出来

Answer 1

存储过程 with as