PDA

View Full Version : Oracle select pagination



jay@moduscreate.com
24 Apr 2007, 5:44 AM
i'm a rare user of Oracle + PHP here (OPAL). I thought i'd share my discovery.

Working on using the grid + pagination .


SELECT *

FROM (
SELECT
rownum r, date, id, name1, name2
FROM
my table
WHERE
(where clause here)
ORDER by
order by here
)
WHERE R Between 50 AND 100



massage the between numbers for your pagination and you're golden.