Nice, but how did they made that?

[Bonor]

Hi,
I like the way the "Fetch next page" works in PLSql/Developer.
How kan you fetch the next x records in Oracle?

Anyone know the query to accomplish this?
(even with an Order by)

 

[Marco Kalter]

In Oracle PL/SQL it's simply a fetch operation. As long as the cursor is open, and not at its end, you can fetch whenever and however you like.

For other programming environments it depends on the implementation.

 

[Bonor]

Ofcourse!
Thanks!