aspose file tools*
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
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:
subject: records between sequence numbers
Similar Threads
Problem faced due to skipping sequence numbers when generated from inside JMS Queues during message
Please help
Difference between Indexes and Sequences
need your help :new synchronized problem
Exactly match searching in URLYBird