wood burning stoves 2.0*
The moose likes JDBC and the fly likes records between sequence numbers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: http://aspose.com/file-tools
subject: records between sequence numbers
Similar Threads
Difference between Indexes and Sequences
need your help :new synchronized problem
Exactly match searching in URLYBird
Problem faced due to skipping sequence numbers when generated from inside JMS Queues during message
Please help