select
    rnum,
    count(decode(chk,1,chk)) "1",
    count(decode(chk,2,chk)) "2",
    count(decode(chk,3,chk)) "3",
    count(decode(chk,4,chk)) "4",
    count(decode(chk,5,chk)) "5"
from
    (
    select
        b.rnum,
        decode(b.rnum,
        1,substr(no,1,1),
        2,substr(no,2,1),
        3,substr(no,3,1),
        4,substr(no,4,1),
        5,substr(no,5,1),
        6,substr(no,6,1),
        7,substr(no,7,1),
        8,substr(no,8,1),
        9,substr(no,9,1),
        10,substr(no,10,1),
        11,substr(no,11,1),
        12,substr(no,12,1),
        13,substr(no,13,1),
        14,substr(no,14,1),
        15,substr(no,15,1),
        16,substr(no,16,1),
        17,substr(no,17,1),
        18,substr(no,18,1)
        ) chk
    from
        (
        select gkkn_chk no, length(gkkn_chk) len from omrchk
        where work_yymm = '200311' and yymm_seri = '01'
         ) a,
        (
        select rownum rnum from copy_t
        ) b
    where b.rnum <= a.len
)
group by rnum