File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes records between sequence numbers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "records between sequence numbers" Watch "records between sequence numbers" New topic

records between sequence numbers

sumanth kumar

Joined: Jul 29, 2005
Posts: 22
We have thousands of records with sequence numbers in the oracle database, we need to retrieve a number of records between two sequence numbers, i.e. to retrieve records between 100 and 200 sequence numbers. Could some one help me to find a query to fetch records.
Carol Enderlin
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
try "between", or use >= and <=

google oracle between
I agree. Here's the link:
subject: records between sequence numbers
It's not a secret anymore!