1 /*** $Id: HibernateOracleNTopWrapperAction.java,v 1.1.1.1 2004/05/18 10:50:17 mochoa Exp $ */
2 package org.j2ee.dao.util;
3
4
5 /***
6 * Last modified $Date: 2004/05/18 10:50:17 $
7 * @version $Revision: 1.1.1.1 $
8 * @author mochoa (mochoa@users.sourceforge.net) */
9 public class HibernateOracleNTopWrapperAction extends AbstractPageByPageAction {
10
11 public HibernateOracleNTopWrapperAction() {
12 }
13
14 public HibernateOracleNTopWrapperAction(int fromNo, int toNo) {
15 super(fromNo,toNo);
16 }
17
18 /***
19 *
20 * @return an String using Oracle's syntax for Limit—with offset querys.
21 * http://troels.arvin.dk/db/rdbms/ for more information.
22 */
23 public String getSQL() {
24 return "SELECT * FROM (SELECT ROWNUM as rn,q.* FROM ("+action.getSQL()+") q ) WHERE rn>=:firstRow AND rn<=:lastRow";
25 }
26 }
This page was automatically generated by Maven