EBS Customizations (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center