Home » SQL & PL/SQL » SQL & PL/SQL » Selecting records in chunks
Selecting records in chunks [message #185] Thu, 24 January 2002 17:15 Go to next message
Praveen Edem
Messages: 3
Registered: January 2002
Junior Member
We require to select record from a table in chunks (like ronum 100 to 200) and order it alphabetically.
We have taken the following approach. Fire two select queries one from 0 to 100, order it by some column, then fire another select query from 0 to 200, order it by some column and use the minus operator between the two.
Is there any other simple way (using only one select query).
Thanks in advance
Re: Selecting records in chunks [message #189 is a reply to message #185] Fri, 25 January 2002 04:11 Go to previous message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
Your best bet is find the unique key on the table and select your records based on the unique key ranges.

Previous Topic: Algorithm of similar text search with a percentage like result
Next Topic: Uploading Files in Oracle
Goto Forum:

Current Time: Thu Aug 06 09:10:45 CDT 2020