오라클 버전때문인지 connect by 절을 쓰면 최대 100로우만 생기네요
그래서 copy_t 테이블을 엮어서..

-- 1, 2, 3 and etc

select q
,rn
,lpad(' ', ((n * 2 - 1) - lengthb(str)) / 2, ' ') || str ||
lpad(' ', ((n * 2 - 1) - lengthb(str)) / 2, ' ')
from (select q
,n
,rn rn
,greatest(case
when rn <= n then
rpad('*', (rn * 2) - 1, '*')
else
' '
end, case
when rn - trunc(n / 3) > 0 then
rpad('*', (n - (rn - trunc(n / 3) - 1)) * 2 - 1, '*')
else
' '
end) str
from (select 'No.1' q
,8 n
from dual
union all
select 'No.2'
,7 n
from dual
union all
select 'No.3'
,6 n
from dual
union all
select 'No.etc'
,50 n
from dual)
,copy_t t
where t.rn <= n + trunc(n / 3));


-- 4, 5

select q, lpad(' ', (rowcnt - lengthb(str)) / 2, ' ') || str ||
lpad(' ', (rowcnt - lengthb(str)) / 2, ' ')
from (select q, rowcnt
,rpad('*', (rowcnt) - abs(rn - n) * 2, '*') str
from (select 'No.4' q, 8 n
,8 * 2 - 1 rowcnt
from dual
union all
select 'No.5' q, 4 n
,4 * 2 - 1 rowcnt
from dual)
,copy_t
where rn <= rowcnt);