public interface OrderByNullPrecedence
Sort.NullHandling
option of an ORDER BY
sort expression is to be evaluated.Modifier and Type | Interface and Description |
---|---|
static class |
OrderByNullPrecedence.SqlStandardOrderByNullPrecedence
An
OrderByNullPrecedence implementation for databases conforming to the SQL standard which uses
NULLS FIRST and NULLS LAST in ORDER BY sort expressions to make null values appear before
or after non-null values in the result set. |
Modifier and Type | Field and Description |
---|---|
static OrderByNullPrecedence |
NONE
An
OrderByNullPrecedence that can be used for databases that do not support the SQL standard usage of
NULLS FIRST and NULLS LAST in ORDER BY sort expressions to control where null values appear
respective to non-null values in the result set. |
static OrderByNullPrecedence |
SQL_STANDARD
An
OrderByNullPrecedence that can be used for databases conforming to the SQL standard which uses
NULLS FIRST and NULLS LAST in ORDER BY sort expressions to make null values appear before
or after non-null values in the result set. |
Modifier and Type | Method and Description |
---|---|
String |
evaluate(Sort.NullHandling nullHandling)
Converts a
Sort.NullHandling option to the appropriate SQL text to be included an ORDER BY sort
expression. |
static final OrderByNullPrecedence SQL_STANDARD
OrderByNullPrecedence
that can be used for databases conforming to the SQL standard which uses
NULLS FIRST
and NULLS LAST
in ORDER BY
sort expressions to make null values appear before
or after non-null values in the result set.static final OrderByNullPrecedence NONE
OrderByNullPrecedence
that can be used for databases that do not support the SQL standard usage of
NULLS FIRST
and NULLS LAST
in ORDER BY
sort expressions to control where null values appear
respective to non-null values in the result set.String evaluate(Sort.NullHandling nullHandling)
Sort.NullHandling
option to the appropriate SQL text to be included an ORDER BY
sort
expression.Copyright © 2017–2022 Pivotal Software, Inc.. All rights reserved.