aspose file tools*
The moose likes JDBC 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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Similar Threads
Get Updated Record
Selecting random rows
Query to fetch 100 records in 1000
sqlserver select where rownum between
Pagination Query in Oracle