How to do Paging with Oracle?

Answer

SELECT*FROM(SELECT a.*, rownum r__
    FROM(SELECT*FROM ORDERS WHERE CustomerID LIKE'A%'ORDERBY OrderDate DESC, ShippingDate DESC) a
    WHERE rownum <((pageNumber * pageSize)+1))WHERE r__ >=(((pageNumber-1)* pageSize)+1)