how to retrieve data every page 10 rows
Oracle OPM
12.2.10
there is a requirement to dispaly, every page 10 records, how to achieve this with sql statement
first page 1..10
second page from 11..20
if i click to next third page should be 21..30 likewise
SELECT * FROM XXINK_TEST
ORDER BY INV_DATE DESC, ISSUE_TIME DESC
please i need help
Regards,