求教贴 有没有会分页的大神

楼主写好一段代码，要求分页查询，每页五条记录，已写好的代码如下
select hm.plate_number,
hm.creation_date,
hw.register_line_id,
hw.product_id ,
hw.uom_code,
eip.product_name,
t.unit_price,
t.status
from test_car_register_header hm,
test_car_register_line hw,
test_products eip,
test_product_price_l t
where hm.register_header_id=hw.register_header_id
and hw.product_id=eip.product_id
and eip.product_id =t.product_id (+)
and t.status='APPROVED'
order by creation_date DESC