Package com.exasol.adapter.dialects

Enum SqlDialect.NullSorting

java.lang.Object

java.lang.Enum<SqlDialect.NullSorting>

com.exasol.adapter.dialects.SqlDialect.NullSorting

All Implemented Interfaces:

Serializable, Comparable<SqlDialect.NullSorting>

Enclosing interface:

SqlDialect

public static enum SqlDialect.NullSorting
extends Enum<SqlDialect.NullSorting>

Strategies for sorting NULL values.

Enum Constant Summary

Enum Constants

Enum Constant	Description
NULLS_SORTED_AT_END	Independently of the actual search order NULL values always appear at the end of the result set
NULLS_SORTED_AT_START	Independently of the actual search order NULL values always appear at the start of the result set
NULLS_SORTED_HIGH	NULL values appear at the start of the result set when sorted in descending order, and at the end when sorted ascending
NULLS_SORTED_LOW	NULLvalues appear at the end of the result set when sorted in descending order, and at the start when sorted ascending

Method Summary

Modifier and Type	Method	Description
static SqlDialect.NullSorting	valueOf(String name)	Returns the enum constant of this type with the specified name.
static SqlDialect.NullSorting[]	values()	Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

NULLS_SORTED_AT_END

public static final SqlDialect.NullSorting NULLS_SORTED_AT_END

Independently of the actual search order NULL values always appear at the end of the result set

NULLS_SORTED_AT_START

public static final SqlDialect.NullSorting NULLS_SORTED_AT_START

Independently of the actual search order NULL values always appear at the start of the result set

NULLS_SORTED_HIGH

public static final SqlDialect.NullSorting NULLS_SORTED_HIGH

NULL values appear at the start of the result set when sorted in descending order, and at the end when sorted ascending

NULLS_SORTED_LOW

public static final SqlDialect.NullSorting NULLS_SORTED_LOW

NULLvalues appear at the end of the result set when sorted in descending order, and at the start when sorted ascending

Method Detail

values

public static SqlDialect.NullSorting[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (SqlDialect.NullSorting c : SqlDialect.NullSorting.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static SqlDialect.NullSorting valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name

NullPointerException - if the argument is null