Package com.exasol.adapter.sql

Enum ScalarFunction

java.lang.Object

java.lang.Enum<ScalarFunction>

com.exasol.adapter.sql.ScalarFunction

All Implemented Interfaces:

Serializable, Comparable<ScalarFunction>

public enum ScalarFunction
extends Enum<ScalarFunction>

List of all scalar functions supported by EXASOL. Note that predicates are defined separately in Predicate.

Enum Constant Summary

Enum Constants

Enum Constant	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	Description
boolean	isSimple()	True if the function is simple, i.e.
static ScalarFunction	valueOf(String name)	Returns the enum constant of this type with the specified name.
static ScalarFunction[]	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 ScalarFunction ADD

SUB

public static final ScalarFunction SUB

MULT

public static final ScalarFunction MULT

FLOAT_DIV

public static final ScalarFunction FLOAT_DIV

NEG

public static final ScalarFunction NEG

ABS

public static final ScalarFunction ABS

ACOS

public static final ScalarFunction ACOS

ASIN

public static final ScalarFunction ASIN

ATAN

public static final ScalarFunction ATAN

ATAN2

public static final ScalarFunction ATAN2

CEIL

public static final ScalarFunction CEIL

COS

public static final ScalarFunction COS

COSH

public static final ScalarFunction COSH

COT

public static final ScalarFunction COT

DEGREES

public static final ScalarFunction DEGREES

DIV

public static final ScalarFunction DIV

EXP

public static final ScalarFunction EXP

FLOOR

public static final ScalarFunction FLOOR

GREATEST

public static final ScalarFunction GREATEST

LEAST

public static final ScalarFunction LEAST

LN

public static final ScalarFunction LN

LOG

public static final ScalarFunction LOG

MOD

public static final ScalarFunction MOD

POWER

public static final ScalarFunction POWER

RADIANS

public static final ScalarFunction RADIANS

RAND

public static final ScalarFunction RAND

ROUND

public static final ScalarFunction ROUND

SIGN

public static final ScalarFunction SIGN

SIN

public static final ScalarFunction SIN

SINH

public static final ScalarFunction SINH

SQRT

public static final ScalarFunction SQRT

TAN

public static final ScalarFunction TAN

TANH

public static final ScalarFunction TANH

TRUNC

public static final ScalarFunction TRUNC

ASCII

public static final ScalarFunction ASCII

BIT_LENGTH

public static final ScalarFunction BIT_LENGTH

CHR

public static final ScalarFunction CHR

COLOGNE_PHONETIC

public static final ScalarFunction COLOGNE_PHONETIC

CONCAT

public static final ScalarFunction CONCAT

DUMP

public static final ScalarFunction DUMP

EDIT_DISTANCE

public static final ScalarFunction EDIT_DISTANCE

INSERT

public static final ScalarFunction INSERT

INSTR

public static final ScalarFunction INSTR

LENGTH

public static final ScalarFunction LENGTH

LOCATE

public static final ScalarFunction LOCATE

LOWER

public static final ScalarFunction LOWER

LPAD

public static final ScalarFunction LPAD

LTRIM

public static final ScalarFunction LTRIM

OCTET_LENGTH

public static final ScalarFunction OCTET_LENGTH

REGEXP_INSTR

public static final ScalarFunction REGEXP_INSTR

REGEXP_REPLACE

public static final ScalarFunction REGEXP_REPLACE

REGEXP_SUBSTR

public static final ScalarFunction REGEXP_SUBSTR

REPEAT

public static final ScalarFunction REPEAT

REPLACE

public static final ScalarFunction REPLACE

REVERSE

public static final ScalarFunction REVERSE

RIGHT

public static final ScalarFunction RIGHT

RPAD

public static final ScalarFunction RPAD

RTRIM

public static final ScalarFunction RTRIM

SOUNDEX

public static final ScalarFunction SOUNDEX

SPACE

public static final ScalarFunction SPACE

SUBSTR

public static final ScalarFunction SUBSTR

TRANSLATE

public static final ScalarFunction TRANSLATE

TRIM

public static final ScalarFunction TRIM

UNICODE

public static final ScalarFunction UNICODE

UNICODECHR

public static final ScalarFunction UNICODECHR

UPPER

public static final ScalarFunction UPPER

ADD_DAYS

public static final ScalarFunction ADD_DAYS

ADD_HOURS

public static final ScalarFunction ADD_HOURS

ADD_MINUTES

public static final ScalarFunction ADD_MINUTES

ADD_MONTHS

public static final ScalarFunction ADD_MONTHS

ADD_SECONDS

public static final ScalarFunction ADD_SECONDS

ADD_WEEKS

public static final ScalarFunction ADD_WEEKS

ADD_YEARS

public static final ScalarFunction ADD_YEARS

CONVERT_TZ

public static final ScalarFunction CONVERT_TZ

CURRENT_DATE

public static final ScalarFunction CURRENT_DATE

CURRENT_TIMESTAMP

public static final ScalarFunction CURRENT_TIMESTAMP

DATE_TRUNC

public static final ScalarFunction DATE_TRUNC

DAY

public static final ScalarFunction DAY

DAYS_BETWEEN

public static final ScalarFunction DAYS_BETWEEN

DBTIMEZONE

public static final ScalarFunction DBTIMEZONE

EXTRACT

public static final ScalarFunction EXTRACT

HOURS_BETWEEN

public static final ScalarFunction HOURS_BETWEEN

LOCALTIMESTAMP

public static final ScalarFunction LOCALTIMESTAMP

MINUTE

public static final ScalarFunction MINUTE

MINUTES_BETWEEN

public static final ScalarFunction MINUTES_BETWEEN

MONTH

public static final ScalarFunction MONTH

MONTHS_BETWEEN

public static final ScalarFunction MONTHS_BETWEEN

NUMTODSINTERVAL

public static final ScalarFunction NUMTODSINTERVAL

NUMTOYMINTERVAL

public static final ScalarFunction NUMTOYMINTERVAL

POSIX_TIME

public static final ScalarFunction POSIX_TIME

SECOND

public static final ScalarFunction SECOND

SECONDS_BETWEEN

public static final ScalarFunction SECONDS_BETWEEN

SESSIONTIMEZONE

public static final ScalarFunction SESSIONTIMEZONE

SYSDATE

public static final ScalarFunction SYSDATE

SYSTIMESTAMP

public static final ScalarFunction SYSTIMESTAMP

WEEK

public static final ScalarFunction WEEK

YEAR

public static final ScalarFunction YEAR

YEARS_BETWEEN

public static final ScalarFunction YEARS_BETWEEN

ST_X

public static final ScalarFunction ST_X

ST_Y

public static final ScalarFunction ST_Y

ST_ENDPOINT

public static final ScalarFunction ST_ENDPOINT

ST_ISCLOSED

public static final ScalarFunction ST_ISCLOSED

ST_ISRING

public static final ScalarFunction ST_ISRING

ST_LENGTH

public static final ScalarFunction ST_LENGTH

ST_NUMPOINTS

public static final ScalarFunction ST_NUMPOINTS

ST_POINTN

public static final ScalarFunction ST_POINTN

ST_STARTPOINT

public static final ScalarFunction ST_STARTPOINT

ST_AREA

public static final ScalarFunction ST_AREA

ST_EXTERIORRING

public static final ScalarFunction ST_EXTERIORRING

ST_INTERIORRINGN

public static final ScalarFunction ST_INTERIORRINGN

ST_NUMINTERIORRINGS

public static final ScalarFunction ST_NUMINTERIORRINGS

ST_GEOMETRYN

public static final ScalarFunction ST_GEOMETRYN

ST_NUMGEOMETRIES

public static final ScalarFunction ST_NUMGEOMETRIES

ST_BOUNDARY

public static final ScalarFunction ST_BOUNDARY

ST_BUFFER

public static final ScalarFunction ST_BUFFER

ST_CENTROID

public static final ScalarFunction ST_CENTROID

ST_CONTAINS

public static final ScalarFunction ST_CONTAINS

ST_CONVEXHULL

public static final ScalarFunction ST_CONVEXHULL

ST_CROSSES

public static final ScalarFunction ST_CROSSES

ST_DIFFERENCE

public static final ScalarFunction ST_DIFFERENCE

ST_DIMENSION

public static final ScalarFunction ST_DIMENSION

ST_DISJOINT

public static final ScalarFunction ST_DISJOINT

ST_DISTANCE

public static final ScalarFunction ST_DISTANCE

ST_ENVELOPE

public static final ScalarFunction ST_ENVELOPE

ST_EQUALS

public static final ScalarFunction ST_EQUALS

ST_FORCE2D

public static final ScalarFunction ST_FORCE2D

ST_GEOMETRYTYPE

public static final ScalarFunction ST_GEOMETRYTYPE

ST_INTERSECTION

public static final ScalarFunction ST_INTERSECTION

ST_INTERSECTS

public static final ScalarFunction ST_INTERSECTS

ST_ISEMPTY

public static final ScalarFunction ST_ISEMPTY

ST_ISSIMPLE

public static final ScalarFunction ST_ISSIMPLE

ST_OVERLAPS

public static final ScalarFunction ST_OVERLAPS

ST_SETSRID

public static final ScalarFunction ST_SETSRID

ST_SYMDIFFERENCE

public static final ScalarFunction ST_SYMDIFFERENCE

ST_TOUCHES

public static final ScalarFunction ST_TOUCHES

ST_TRANSFORM

public static final ScalarFunction ST_TRANSFORM

ST_UNION

public static final ScalarFunction ST_UNION

ST_WITHIN

public static final ScalarFunction ST_WITHIN

CAST

public static final ScalarFunction CAST

IS_NUMBER

public static final ScalarFunction IS_NUMBER

IS_BOOLEAN

public static final ScalarFunction IS_BOOLEAN

IS_DATE

public static final ScalarFunction IS_DATE

IS_DSINTERVAL

public static final ScalarFunction IS_DSINTERVAL

IS_YMINTERVAL

public static final ScalarFunction IS_YMINTERVAL

IS_TIMESTAMP

public static final ScalarFunction IS_TIMESTAMP

TO_CHAR

public static final ScalarFunction TO_CHAR

TO_DATE

public static final ScalarFunction TO_DATE

TO_DSINTERVAL

public static final ScalarFunction TO_DSINTERVAL

TO_YMINTERVAL

public static final ScalarFunction TO_YMINTERVAL

TO_NUMBER

public static final ScalarFunction TO_NUMBER

TO_TIMESTAMP

public static final ScalarFunction TO_TIMESTAMP

BIT_AND

public static final ScalarFunction BIT_AND

BIT_CHECK

public static final ScalarFunction BIT_CHECK

BIT_NOT

public static final ScalarFunction BIT_NOT

BIT_OR

public static final ScalarFunction BIT_OR

BIT_SET

public static final ScalarFunction BIT_SET

BIT_TO_NUM

public static final ScalarFunction BIT_TO_NUM

BIT_XOR

public static final ScalarFunction BIT_XOR

CASE

public static final ScalarFunction CASE

CURRENT_SCHEMA

public static final ScalarFunction CURRENT_SCHEMA

CURRENT_SESSION

public static final ScalarFunction CURRENT_SESSION

CURRENT_STATEMENT

public static final ScalarFunction CURRENT_STATEMENT

CURRENT_USER

public static final ScalarFunction CURRENT_USER

HASH_MD5

public static final ScalarFunction HASH_MD5

HASH_SHA

public static final ScalarFunction HASH_SHA

HASH_SHA1

public static final ScalarFunction HASH_SHA1

HASH_SHA256

public static final ScalarFunction HASH_SHA256

HASH_SHA512

public static final ScalarFunction HASH_SHA512

HASH_TIGER

public static final ScalarFunction HASH_TIGER

NULLIFZERO

public static final ScalarFunction NULLIFZERO

SYS_GUID

public static final ScalarFunction SYS_GUID

ZEROIFNULL

public static final ScalarFunction ZEROIFNULL

Method Detail

values

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

Returns:

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

valueOf

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

isSimple

public boolean isSimple()

True if the function is simple, i.e. is handled by SqlFunctionScalar, and false if it has it's own implementation.

Returns:

true if the function is simple