wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes Using oracle Rownum with between keyword 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 "Using oracle Rownum with between keyword" Watch "Using oracle Rownum with between keyword" New topic
Author

Using oracle Rownum with between keyword

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi ,

I am planning to use JDBC Pagination with Oracle (Query based technique ) No caching of results .

When i tried to use rownum with between Option , it didn't gave me any results




But this gave me results .





Please tel me How to solve this ??


Save India From Corruption - Anna Hazare.
Shinil Mohan
Ranch Hand

Joined: Aug 24, 2011
Posts: 37


You can use a nested select to solve this issue. Something like below query

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Thank you very much Mohan .
Shinil Mohan
Ranch Hand

Joined: Aug 24, 2011
Posts: 37

You are welcome ..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using oracle Rownum with between keyword
 
It's not a secret anymore!