This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
Have you checked out Aspose?
subject: records between sequence numbers
It's not a secret anymore!