com.exasol.adapter.capabilities

Enum ScalarFunctionCapability

java.lang.Object

java.lang.Enum<ScalarFunctionCapability>

com.exasol.adapter.capabilities.ScalarFunctionCapability

All Implemented Interfaces:

Serializable, Comparable<ScalarFunctionCapability>

public enum ScalarFunctionCapability
extends Enum<ScalarFunctionCapability>

List of all scalar functions supported by EXASOL. Note that predicates are handled separately in PredicateCapability.

Enum Constant Summary

Enum Constants

Enum Constant and Description
ABS
ACOS
ADD
ADD_DAYS
ADD_HOURS
ADD_MINUTES
ADD_MONTHS
ADD_SECONDS
ADD_WEEKS
ADD_YEARS
ASCII
ASIN
ATAN
ATAN2
BIT_AND
BIT_CHECK
BIT_LENGTH
BIT_NOT
BIT_OR
BIT_SET
BIT_TO_NUM
BIT_XOR
CASE
CAST
CEIL
CHR
COLOGNE_PHONETIC
CONCAT
CONVERT_TZ
COS
COSH
COT
CURRENT_DATE
CURRENT_SCHEMA
CURRENT_SESSION
CURRENT_STATEMENT
CURRENT_TIMESTAMP
CURRENT_USER
DATE_TRUNC
DAY
DAYS_BETWEEN
DBTIMEZONE
DEGREES
DIV
DUMP
EDIT_DISTANCE
EXP
EXTRACT
FLOAT_DIV
FLOOR
GREATEST
HASH_MD5
HASH_SHA
HASH_SHA1
HASH_SHA256
HASH_SHA512
HASH_TIGER
HOURS_BETWEEN
INSERT
INSTR
IS_BOOLEAN
IS_DATE
IS_DSINTERVAL
IS_NUMBER
IS_TIMESTAMP
IS_YMINTERVAL
LEAST
LENGTH
LN
LOCALTIMESTAMP
LOCATE
LOG
LOWER
LPAD
LTRIM
MINUTE
MINUTES_BETWEEN
MOD
MONTH
MONTHS_BETWEEN
MULT
NEG
NULLIFZERO
NUMTODSINTERVAL
NUMTOYMINTERVAL
OCTET_LENGTH
POSIX_TIME
POWER
RADIANS
RAND
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REPEAT
REPLACE
REVERSE
RIGHT
ROUND
RPAD
RTRIM
SECOND
SECONDS_BETWEEN
SESSIONTIMEZONE
SIGN
SIN
SINH
SOUNDEX
SPACE
SQRT
ST_AREA
ST_BOUNDARY
ST_BUFFER
ST_CENTROID
ST_CONTAINS
ST_CONVEXHULL
ST_CROSSES
ST_DIFFERENCE
ST_DIMENSION
ST_DISJOINT
ST_DISTANCE
ST_ENDPOINT
ST_ENVELOPE
ST_EQUALS
ST_EXTERIORRING
ST_FORCE2D
ST_GEOMETRYN
ST_GEOMETRYTYPE
ST_INTERIORRINGN
ST_INTERSECTION
ST_INTERSECTS
ST_ISCLOSED
ST_ISEMPTY
ST_ISRING
ST_ISSIMPLE
ST_LENGTH
ST_NUMGEOMETRIES
ST_NUMINTERIORRINGS
ST_NUMPOINTS
ST_OVERLAPS
ST_POINTN
ST_SETSRID
ST_STARTPOINT
ST_SYMDIFFERENCE
ST_TOUCHES
ST_TRANSFORM
ST_UNION
ST_WITHIN
ST_X
ST_Y
SUB
SUBSTR
SYS_GUID
SYSDATE
SYSTIMESTAMP
TAN
TANH
TO_CHAR
TO_DATE
TO_DSINTERVAL
TO_NUMBER
TO_TIMESTAMP
TO_YMINTERVAL
TRANSLATE
TRIM
TRUNC
UNICODE
UNICODECHR
UPPER
WEEK
YEAR
YEARS_BETWEEN
ZEROIFNULL

Method Summary

Modifier and Type	Method and Description
ScalarFunction	getFunction()
static ScalarFunctionCapability	valueOf(String name) Returns the enum constant of this type with the specified name.
static ScalarFunctionCapability[]	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

ADD

public static final ScalarFunctionCapability ADD

SUB

public static final ScalarFunctionCapability SUB

MULT

public static final ScalarFunctionCapability MULT

FLOAT_DIV

public static final ScalarFunctionCapability FLOAT_DIV

NEG

public static final ScalarFunctionCapability NEG

ABS

public static final ScalarFunctionCapability ABS

ACOS

public static final ScalarFunctionCapability ACOS

ASIN

public static final ScalarFunctionCapability ASIN

ATAN

public static final ScalarFunctionCapability ATAN

ATAN2

public static final ScalarFunctionCapability ATAN2

CEIL

public static final ScalarFunctionCapability CEIL

COS

public static final ScalarFunctionCapability COS

COSH

public static final ScalarFunctionCapability COSH

COT

public static final ScalarFunctionCapability COT

DEGREES

public static final ScalarFunctionCapability DEGREES

DIV

public static final ScalarFunctionCapability DIV

EXP

public static final ScalarFunctionCapability EXP

FLOOR

public static final ScalarFunctionCapability FLOOR

GREATEST

public static final ScalarFunctionCapability GREATEST

LEAST

public static final ScalarFunctionCapability LEAST

LN

public static final ScalarFunctionCapability LN

LOG

public static final ScalarFunctionCapability LOG

MOD

public static final ScalarFunctionCapability MOD

POWER

public static final ScalarFunctionCapability POWER

RADIANS

public static final ScalarFunctionCapability RADIANS

RAND

public static final ScalarFunctionCapability RAND

ROUND

public static final ScalarFunctionCapability ROUND

SIGN

public static final ScalarFunctionCapability SIGN

SIN

public static final ScalarFunctionCapability SIN

SINH

public static final ScalarFunctionCapability SINH

SQRT

public static final ScalarFunctionCapability SQRT

TAN

public static final ScalarFunctionCapability TAN

TANH

public static final ScalarFunctionCapability TANH

TRUNC

public static final ScalarFunctionCapability TRUNC

ASCII

public static final ScalarFunctionCapability ASCII

BIT_LENGTH

public static final ScalarFunctionCapability BIT_LENGTH

CHR

public static final ScalarFunctionCapability CHR

COLOGNE_PHONETIC

public static final ScalarFunctionCapability COLOGNE_PHONETIC

CONCAT

public static final ScalarFunctionCapability CONCAT

DUMP

public static final ScalarFunctionCapability DUMP

EDIT_DISTANCE

public static final ScalarFunctionCapability EDIT_DISTANCE

INSERT

public static final ScalarFunctionCapability INSERT

INSTR

public static final ScalarFunctionCapability INSTR

LENGTH

public static final ScalarFunctionCapability LENGTH

LOCATE

public static final ScalarFunctionCapability LOCATE

LOWER

public static final ScalarFunctionCapability LOWER

LPAD

public static final ScalarFunctionCapability LPAD

LTRIM

public static final ScalarFunctionCapability LTRIM

OCTET_LENGTH

public static final ScalarFunctionCapability OCTET_LENGTH

REGEXP_INSTR

public static final ScalarFunctionCapability REGEXP_INSTR

REGEXP_REPLACE

public static final ScalarFunctionCapability REGEXP_REPLACE

REGEXP_SUBSTR

public static final ScalarFunctionCapability REGEXP_SUBSTR

REPEAT

public static final ScalarFunctionCapability REPEAT

REPLACE

public static final ScalarFunctionCapability REPLACE

REVERSE

public static final ScalarFunctionCapability REVERSE

RIGHT

public static final ScalarFunctionCapability RIGHT

RPAD

public static final ScalarFunctionCapability RPAD

RTRIM

public static final ScalarFunctionCapability RTRIM

SOUNDEX

public static final ScalarFunctionCapability SOUNDEX

SPACE

public static final ScalarFunctionCapability SPACE

SUBSTR

public static final ScalarFunctionCapability SUBSTR

TRANSLATE

public static final ScalarFunctionCapability TRANSLATE

TRIM

public static final ScalarFunctionCapability TRIM

UNICODE

public static final ScalarFunctionCapability UNICODE

UNICODECHR

public static final ScalarFunctionCapability UNICODECHR

UPPER

public static final ScalarFunctionCapability UPPER

ADD_DAYS

public static final ScalarFunctionCapability ADD_DAYS

ADD_HOURS

public static final ScalarFunctionCapability ADD_HOURS

ADD_MINUTES

public static final ScalarFunctionCapability ADD_MINUTES

ADD_MONTHS

public static final ScalarFunctionCapability ADD_MONTHS

ADD_SECONDS

public static final ScalarFunctionCapability ADD_SECONDS

ADD_WEEKS

public static final ScalarFunctionCapability ADD_WEEKS

ADD_YEARS

public static final ScalarFunctionCapability ADD_YEARS

CONVERT_TZ

public static final ScalarFunctionCapability CONVERT_TZ

CURRENT_DATE

public static final ScalarFunctionCapability CURRENT_DATE

CURRENT_TIMESTAMP

public static final ScalarFunctionCapability CURRENT_TIMESTAMP

DATE_TRUNC

public static final ScalarFunctionCapability DATE_TRUNC

DAY

public static final ScalarFunctionCapability DAY

DAYS_BETWEEN

public static final ScalarFunctionCapability DAYS_BETWEEN

DBTIMEZONE

public static final ScalarFunctionCapability DBTIMEZONE

EXTRACT

public static final ScalarFunctionCapability EXTRACT

HOURS_BETWEEN

public static final ScalarFunctionCapability HOURS_BETWEEN

LOCALTIMESTAMP

public static final ScalarFunctionCapability LOCALTIMESTAMP

MINUTE

public static final ScalarFunctionCapability MINUTE

MINUTES_BETWEEN

public static final ScalarFunctionCapability MINUTES_BETWEEN

MONTH

public static final ScalarFunctionCapability MONTH

MONTHS_BETWEEN

public static final ScalarFunctionCapability MONTHS_BETWEEN

NUMTODSINTERVAL

public static final ScalarFunctionCapability NUMTODSINTERVAL

NUMTOYMINTERVAL

public static final ScalarFunctionCapability NUMTOYMINTERVAL

POSIX_TIME

public static final ScalarFunctionCapability POSIX_TIME

SECOND

public static final ScalarFunctionCapability SECOND

SECONDS_BETWEEN

public static final ScalarFunctionCapability SECONDS_BETWEEN

SESSIONTIMEZONE

public static final ScalarFunctionCapability SESSIONTIMEZONE

SYSDATE

public static final ScalarFunctionCapability SYSDATE

SYSTIMESTAMP

public static final ScalarFunctionCapability SYSTIMESTAMP

WEEK

public static final ScalarFunctionCapability WEEK

YEAR

public static final ScalarFunctionCapability YEAR

YEARS_BETWEEN

public static final ScalarFunctionCapability YEARS_BETWEEN

ST_X

public static final ScalarFunctionCapability ST_X

ST_Y

public static final ScalarFunctionCapability ST_Y

ST_ENDPOINT

public static final ScalarFunctionCapability ST_ENDPOINT

ST_ISCLOSED

public static final ScalarFunctionCapability ST_ISCLOSED

ST_ISRING

public static final ScalarFunctionCapability ST_ISRING

ST_LENGTH

public static final ScalarFunctionCapability ST_LENGTH

ST_NUMPOINTS

public static final ScalarFunctionCapability ST_NUMPOINTS

ST_POINTN

public static final ScalarFunctionCapability ST_POINTN

ST_STARTPOINT

public static final ScalarFunctionCapability ST_STARTPOINT

ST_AREA

public static final ScalarFunctionCapability ST_AREA

ST_EXTERIORRING

public static final ScalarFunctionCapability ST_EXTERIORRING

ST_INTERIORRINGN

public static final ScalarFunctionCapability ST_INTERIORRINGN

ST_NUMINTERIORRINGS

public static final ScalarFunctionCapability ST_NUMINTERIORRINGS

ST_GEOMETRYN

public static final ScalarFunctionCapability ST_GEOMETRYN

ST_NUMGEOMETRIES

public static final ScalarFunctionCapability ST_NUMGEOMETRIES

ST_BOUNDARY

public static final ScalarFunctionCapability ST_BOUNDARY

ST_BUFFER

public static final ScalarFunctionCapability ST_BUFFER

ST_CENTROID

public static final ScalarFunctionCapability ST_CENTROID

ST_CONTAINS

public static final ScalarFunctionCapability ST_CONTAINS

ST_CONVEXHULL

public static final ScalarFunctionCapability ST_CONVEXHULL

ST_CROSSES

public static final ScalarFunctionCapability ST_CROSSES

ST_DIFFERENCE

public static final ScalarFunctionCapability ST_DIFFERENCE

ST_DIMENSION

public static final ScalarFunctionCapability ST_DIMENSION

ST_DISJOINT

public static final ScalarFunctionCapability ST_DISJOINT

ST_DISTANCE

public static final ScalarFunctionCapability ST_DISTANCE

ST_ENVELOPE

public static final ScalarFunctionCapability ST_ENVELOPE

ST_EQUALS

public static final ScalarFunctionCapability ST_EQUALS

ST_FORCE2D

public static final ScalarFunctionCapability ST_FORCE2D

ST_GEOMETRYTYPE

public static final ScalarFunctionCapability ST_GEOMETRYTYPE

ST_INTERSECTION

public static final ScalarFunctionCapability ST_INTERSECTION

ST_INTERSECTS

public static final ScalarFunctionCapability ST_INTERSECTS

ST_ISEMPTY

public static final ScalarFunctionCapability ST_ISEMPTY

ST_ISSIMPLE

public static final ScalarFunctionCapability ST_ISSIMPLE

ST_OVERLAPS

public static final ScalarFunctionCapability ST_OVERLAPS

ST_SETSRID

public static final ScalarFunctionCapability ST_SETSRID

ST_SYMDIFFERENCE

public static final ScalarFunctionCapability ST_SYMDIFFERENCE

ST_TOUCHES

public static final ScalarFunctionCapability ST_TOUCHES

ST_TRANSFORM

public static final ScalarFunctionCapability ST_TRANSFORM

ST_UNION

public static final ScalarFunctionCapability ST_UNION

ST_WITHIN

public static final ScalarFunctionCapability ST_WITHIN

CAST

public static final ScalarFunctionCapability CAST

IS_NUMBER

public static final ScalarFunctionCapability IS_NUMBER

IS_BOOLEAN

public static final ScalarFunctionCapability IS_BOOLEAN

IS_DATE

public static final ScalarFunctionCapability IS_DATE

IS_DSINTERVAL

public static final ScalarFunctionCapability IS_DSINTERVAL

IS_YMINTERVAL

public static final ScalarFunctionCapability IS_YMINTERVAL

IS_TIMESTAMP

public static final ScalarFunctionCapability IS_TIMESTAMP

TO_CHAR

public static final ScalarFunctionCapability TO_CHAR

TO_DATE

public static final ScalarFunctionCapability TO_DATE

TO_DSINTERVAL

public static final ScalarFunctionCapability TO_DSINTERVAL

TO_YMINTERVAL

public static final ScalarFunctionCapability TO_YMINTERVAL

TO_NUMBER

public static final ScalarFunctionCapability TO_NUMBER

TO_TIMESTAMP

public static final ScalarFunctionCapability TO_TIMESTAMP

BIT_AND

public static final ScalarFunctionCapability BIT_AND

BIT_CHECK

public static final ScalarFunctionCapability BIT_CHECK

BIT_NOT

public static final ScalarFunctionCapability BIT_NOT

BIT_OR

public static final ScalarFunctionCapability BIT_OR

BIT_SET

public static final ScalarFunctionCapability BIT_SET

BIT_TO_NUM

public static final ScalarFunctionCapability BIT_TO_NUM

BIT_XOR

public static final ScalarFunctionCapability BIT_XOR

CASE

public static final ScalarFunctionCapability CASE

CURRENT_SCHEMA

public static final ScalarFunctionCapability CURRENT_SCHEMA

CURRENT_SESSION

public static final ScalarFunctionCapability CURRENT_SESSION

CURRENT_STATEMENT

public static final ScalarFunctionCapability CURRENT_STATEMENT

CURRENT_USER

public static final ScalarFunctionCapability CURRENT_USER

HASH_MD5

public static final ScalarFunctionCapability HASH_MD5

HASH_SHA

public static final ScalarFunctionCapability HASH_SHA

HASH_SHA1

public static final ScalarFunctionCapability HASH_SHA1

HASH_SHA256

public static final ScalarFunctionCapability HASH_SHA256

HASH_SHA512

public static final ScalarFunctionCapability HASH_SHA512

HASH_TIGER

public static final ScalarFunctionCapability HASH_TIGER

NULLIFZERO

public static final ScalarFunctionCapability NULLIFZERO

SYS_GUID

public static final ScalarFunctionCapability SYS_GUID

ZEROIFNULL

public static final ScalarFunctionCapability ZEROIFNULL

Method Detail

values

public static ScalarFunctionCapability[] 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 (ScalarFunctionCapability c : ScalarFunctionCapability.values())
    System.out.println(c);

Returns:

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

valueOf

public static ScalarFunctionCapability 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

getFunction

public ScalarFunction getFunction()