data source table:
CONNECT BY LEVEL<=t.count
In Oracle 11g+, you can use recursive queries:
with cte(name, ind, count) as ( select t.name, 1 as ind, t.count from t union all select cte.name, cte.ind + 1, cte.count from cte where cte.ind < cte.count ) select cte.name || cte.ind from cte;
I prefer recursive CTEs to
CONNECT BY because the former are standard and supported by most databases.