with tbl as (select level lv from dual connect by level <= 1000), prm as (select 10 prc from dual) select mod(lv, 100) + 1 pp, lv from tbl t, prm p where mod(lv, 100) + 1 <= prc