select o.*
from (select o.*
           , row_number() over (order by o.table_name) rw
      from all_tables o
     ) o
where o.rw >= 10
  and o.rw < 20