public class Oracle12LimitHandler extends AbstractLimitHandler
LimitHandler
for databases which support the
ANSI SQL standard syntax FETCH FIRST m ROWS ONLY
and OFFSET n ROWS FETCH NEXT m ROWS ONLY
.Modifier and Type | Field and Description |
---|---|
boolean |
bindLimitParametersInReverseOrder |
static Oracle12LimitHandler |
INSTANCE |
boolean |
useMaxForLimit |
Modifier and Type | Method and Description |
---|---|
boolean |
bindLimitParametersInReverseOrder()
ANSI SQL defines the LIMIT clause to be in the form LIMIT offset, limit.
|
String |
processSql(String sql,
QueryParameters queryParameters)
Return processed SQL query.
|
String |
processSql(String sql,
RowSelection selection)
Return processed SQL query.
|
boolean |
supportsLimit()
Does this handler support some form of limiting query results
via a SQL clause?
|
boolean |
useMaxForLimit()
Does the LIMIT clause take a "maximum" row number instead
of a total number of returned rows?
This is easiest understood via an example.
|
bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersFirst, convertToFirstRowValue, forceLimitUsage, getMaxOrLimit, setMaxRows, supportsLimitOffset, supportsVariableLimit
public boolean bindLimitParametersInReverseOrder
public boolean useMaxForLimit
public static final Oracle12LimitHandler INSTANCE
public String processSql(String sql, RowSelection selection)
LimitHandler
processSql
in interface LimitHandler
processSql
in class AbstractLimitHandler
sql
- the SQL query to process.selection
- the selection criteria for rows.public String processSql(String sql, QueryParameters queryParameters)
LimitHandler
sql
- the SQL query to process.queryParameters
- the queryParameters.public final boolean supportsLimit()
LimitHandler
supportsLimit
in interface LimitHandler
supportsLimit
in class AbstractLimitHandler
public boolean bindLimitParametersInReverseOrder()
AbstractLimitHandler
bindLimitParametersInReverseOrder
in class AbstractLimitHandler
public boolean useMaxForLimit()
AbstractLimitHandler
useMaxForLimit
in class AbstractLimitHandler
Copyright © 2001-2021 Red Hat, Inc. All Rights Reserved.