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
Author

records between sequence numbers

sumanth kumar
Greenhorn

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
drifter
Ranch Hand

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

google oracle between
 
 
subject: records between sequence numbers