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, supportsVariableLimitpublic boolean bindLimitParametersInReverseOrder
public boolean useMaxForLimit
public static final Oracle12LimitHandler INSTANCE
public String processSql(String sql, RowSelection selection)
LimitHandlerprocessSql in interface LimitHandlerprocessSql in class AbstractLimitHandlersql - the SQL query to process.selection - the selection criteria for rows.public String processSql(String sql, QueryParameters queryParameters)
LimitHandlersql - the SQL query to process.queryParameters - the queryParameters.public final boolean supportsLimit()
LimitHandlersupportsLimit in interface LimitHandlersupportsLimit in class AbstractLimitHandlerpublic boolean bindLimitParametersInReverseOrder()
AbstractLimitHandlerbindLimitParametersInReverseOrder in class AbstractLimitHandlerpublic boolean useMaxForLimit()
AbstractLimitHandleruseMaxForLimit in class AbstractLimitHandlerCopyright © 2001-2021 Red Hat, Inc. All Rights Reserved.