io.ebean.platform.oracle.OracleRownumBasicLimiter Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ebean-platform-oracle Show documentation

There is a newer version: 15.8.1

Show newest version

package io.ebean.platform.oracle;

import io.ebean.config.dbplatform.BasicSqlLimiter;

/**
 * Row limiter for Oracle 9,10,11 using rownum.
 */
final class OracleRownumBasicLimiter implements BasicSqlLimiter {

  @Override
  public String limit(String dbSql, int firstRow, int maxRows) {
    if (firstRow < 1 && maxRows < 1) {
      return dbSql;
    }
    StringBuilder sb = new StringBuilder(60 + dbSql.length());
    int lastRow = maxRows;
    if (lastRow > 0) {
      lastRow += firstRow;
    }
    sb.append("select * from (select ");
    if (maxRows > 0) {
      sb.append("/*+ FIRST_ROWS(").append(maxRows).append(") */ ");
    }
    sb.append("a.*, rownum rn_ from (");
    sb.append(dbSql).append(") a ");
    if (lastRow > 0) {
      sb.append(" where rownum <= ").append(lastRow);
    }
    sb.append(") ");
    if (firstRow > 0) {
      sb.append(" where rn_ > ").append(firstRow);
    }
    return sb.toString();
  }
}