Stem-and-leaf display(통계학)
with t as (
select 44 v from dual union all
select 46 from dual union all
select 47 from dual union all
select 49 from dual union all
select 63 from dual union all
select 64 from dual union all
select 66 from dual union all
select 68 from dual union all
select 68 from dual union all
select 72 from dual union all
select 72 from dual union all
select 75 from dual union all
select 76 from dual union all
select 81 from dual union all
select 84 from dual union all
select 88 from dual union all
select 106 from dual)
select x.lv v
, replace(wm_concat(substr(v, length(v))), ',') str
from t
right join
(select level lv from dual connect by level<=10) x
on substr(t.v, 1, length(t.v)-1)=x.lv
group by x.lv
order by x.lv+0
V STR
---------- ----------
1
2
3
4 4679
5
6 38468
7 2652
8 184
9
10 6