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_LROTATE`
`BIT_LSHIFT`
`BIT_NOT`
`BIT_OR`
`BIT_RROTATE`
`BIT_RSHIFT`
`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`
`FROM_POSIX_TIME`
`GREATEST`
`HASH_MD5`
`HASH_SHA1`
`HASH_SHA256`
`HASH_SHA512`
`HASH_TIGER`
`HASHTYPE_MD5`
`HASHTYPE_SHA1`
`HASHTYPE_SHA256`
`HASHTYPE_SHA512`
`HASHTYPE_TIGER`
`HOUR`
`HOURS_BETWEEN`
`INITCAP`
`INSERT`
`INSTR`
`IS_BOOLEAN`
`IS_DATE`
`IS_DSINTERVAL`
`IS_NUMBER`
`IS_TIMESTAMP`
`IS_YMINTERVAL`
`JSON_VALUE`
`LEAST`
`LENGTH`
`LN`
`LOCALTIMESTAMP`
`LOCATE`
`LOG`
`LOWER`
`LPAD`
`LTRIM`
`MIN_SCALE`
`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`
`SESSION_PARAMETER`
`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

All Methods Static Methods Instance Methods Concrete Methods
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

INITCAP

public static final ScalarFunction INITCAP

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

FROM_POSIX_TIME

public static final ScalarFunction FROM_POSIX_TIME

HOUR

public static final ScalarFunction HOUR

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_LROTATE

public static final ScalarFunction BIT_LROTATE

BIT_LSHIFT

public static final ScalarFunction BIT_LSHIFT

BIT_NOT

public static final ScalarFunction BIT_NOT

BIT_OR

public static final ScalarFunction BIT_OR

BIT_RROTATE

public static final ScalarFunction BIT_RROTATE

BIT_RSHIFT

public static final ScalarFunction BIT_RSHIFT

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

HASHTYPE_MD5

public static final ScalarFunction HASHTYPE_MD5

HASH_SHA1

public static final ScalarFunction HASH_SHA1

HASHTYPE_SHA1

public static final ScalarFunction HASHTYPE_SHA1

HASH_SHA256

public static final ScalarFunction HASH_SHA256

HASHTYPE_SHA256

public static final ScalarFunction HASHTYPE_SHA256

HASH_SHA512

public static final ScalarFunction HASH_SHA512

HASHTYPE_SHA512

public static final ScalarFunction HASHTYPE_SHA512

HASH_TIGER

public static final ScalarFunction HASH_TIGER

HASHTYPE_TIGER

public static final ScalarFunction HASHTYPE_TIGER

NULLIFZERO

public static final ScalarFunction NULLIFZERO

SYS_GUID

public static final ScalarFunction SYS_GUID

ZEROIFNULL

public static final ScalarFunction ZEROIFNULL

JSON_VALUE

public static final ScalarFunction JSON_VALUE

SESSION_PARAMETER

public static final ScalarFunction SESSION_PARAMETER

MIN_SCALE

public static final ScalarFunction MIN_SCALE

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

Enum ScalarFunction

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

ADD

SUB

MULT

FLOAT_DIV

NEG

ABS

ACOS

ASIN

ATAN

ATAN2

CEIL

COS

COSH

COT

DEGREES

DIV

EXP

FLOOR

GREATEST

LEAST

LN

LOG

MOD

POWER

RADIANS

RAND

ROUND

SIGN

SIN

SINH

SQRT

TAN

TANH

TRUNC

ASCII

BIT_LENGTH

CHR

COLOGNE_PHONETIC

CONCAT

DUMP

EDIT_DISTANCE

INITCAP

INSERT

INSTR

LENGTH

LOCATE

LOWER

LPAD

LTRIM

OCTET_LENGTH

REGEXP_INSTR

REGEXP_REPLACE

REGEXP_SUBSTR

REPEAT

REPLACE

REVERSE

RIGHT

RPAD

RTRIM

SOUNDEX

SPACE

SUBSTR

TRANSLATE

TRIM

UNICODE

UNICODECHR

UPPER

ADD_DAYS

ADD_HOURS

ADD_MINUTES

ADD_MONTHS

ADD_SECONDS

ADD_WEEKS

ADD_YEARS