create table t (
  id int,
  mn int,
  mx int
);
insert into t values (1, 5, 10);
insert into t values (2, 3, 5);

with rws as (
  select rownum x from dual connect by level <= 10
)
  select id, x from t
  join   rws r
  on     r.x >= mn
  and    r.x < mx
  order  by 1, 2;

        ID          X
---------- ----------
         1          5
         1          6
         1          7
         1          8
         1          9
         2          3
         2          4