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