Oracle DB Paging

you can use the following query to get the desired search results

SELECT Orders2.*, rownum as RN
FROM (select * from Orders where account_id=iAccountID ORDER BY Order_Date desc ) Orders2)
WHERE RN >= istartIndex*ipageSize +1 and RN <= (istartIndex+1)*ipageSize;