Oracle查询第几条数据

如下查询第9条数据，注意大的范围在前，小的范围在后

(select a.OBJECT_NAME Name from all_objects a where owner = 'LISRO' and a.OBJECT_TYPE='TABLE' and rownum<10)

minus

(select a.OBJECT_NAME Name from all_objects a where owner = 'LISRO' and a.OBJECT_TYPE='TABLE' and rownum<9)