Oracle分页查询

当有排序时oracle分页查询

 select *
   from (select rownum r, t.*
           from (select * from DATA_SCHEME_SCHEDUL order by update_time desc) t
          where rownum <= 5)
  where r > 0