gods | qty
-------------------
a | 10
이렇게 a가 10개가 있는데요
이것을 10줄로 표현하는 방법이 뭐가 있을까요???
a 1
a 1 .....
이런식으로요
with tmp as ( select 'a' as goods, 10 as qty from dual union all select 'b' as goods, 4 as qty from dual ) select goods from tmp a, (SELECT LEVEL no FROM dual CONNECT BY LEVEL <= 100) b where b.no <= a.qty