Package com.exasol.adapter.sql

Enum ScalarFunction

    • Enum Constant Detail

      • FLOAT_DIV

        public static final ScalarFunction FLOAT_DIV
        Float div scalar function.

      • ATAN2

        public static final ScalarFunction ATAN2
        Atan 2 scalar function.

      • DEGREES

        public static final ScalarFunction DEGREES
        Degrees scalar function.

      • FLOOR

        public static final ScalarFunction FLOOR
        Floor scalar function.

      • GREATEST

        public static final ScalarFunction GREATEST
        Greatest scalar function.

      • LEAST

        public static final ScalarFunction LEAST
        Least scalar function.

      • POWER

        public static final ScalarFunction POWER
        Power scalar function.

      • RADIANS

        public static final ScalarFunction RADIANS
        Radians scalar function.

      • ROUND

        public static final ScalarFunction ROUND
        Round scalar function.

      • TRUNC

        public static final ScalarFunction TRUNC
        Trunc scalar function.

      • WIDTH_BUCKET

        public static final ScalarFunction WIDTH_BUCKET
        WIDTH_BUCKET scalar function.

      • ASCII

        public static final ScalarFunction ASCII
        Ascii scalar function.

      • BIT_LENGTH

        public static final ScalarFunction BIT_LENGTH
        Bit length scalar function.

      • COLOGNE_PHONETIC

        public static final ScalarFunction COLOGNE_PHONETIC
        Cologne phonetic scalar function.

      • CONCAT

        public static final ScalarFunction CONCAT
        Concat scalar function.

      • EDIT_DISTANCE

        public static final ScalarFunction EDIT_DISTANCE
        Edit distance scalar function.

      • INITCAP

        public static final ScalarFunction INITCAP
        Initcap scalar function.

      • INSERT

        public static final ScalarFunction INSERT
        Insert scalar function.

      • INSTR

        public static final ScalarFunction INSTR
        Instr scalar function.

      • LENGTH

        public static final ScalarFunction LENGTH
        Length scalar function.

      • LOCATE

        public static final ScalarFunction LOCATE
        Locate scalar function.

      • LOWER

        public static final ScalarFunction LOWER
        Lower scalar function.

      • LTRIM

        public static final ScalarFunction LTRIM
        Ltrim scalar function.

      • OCTET_LENGTH

        public static final ScalarFunction OCTET_LENGTH
        Octet length scalar function.

      • REGEXP_INSTR

        public static final ScalarFunction REGEXP_INSTR
        Regexp instr scalar function.

      • REGEXP_REPLACE

        public static final ScalarFunction REGEXP_REPLACE
        Regexp replace scalar function.

      • REGEXP_SUBSTR

        public static final ScalarFunction REGEXP_SUBSTR
        Regexp substr scalar function.

      • REPEAT

        public static final ScalarFunction REPEAT
        Repeat scalar function.

      • REPLACE

        public static final ScalarFunction REPLACE
        Replace scalar function.

      • REVERSE

        public static final ScalarFunction REVERSE
        Reverse scalar function.

      • RIGHT

        public static final ScalarFunction RIGHT
        Right scalar function.

      • RTRIM

        public static final ScalarFunction RTRIM
        Rtrim scalar function.

      • SOUNDEX

        public static final ScalarFunction SOUNDEX
        Soundex scalar function.

      • SPACE

        public static final ScalarFunction SPACE
        Space scalar function.

      • SUBSTR

        public static final ScalarFunction SUBSTR
        Substr scalar function.

      • TRANSLATE

        public static final ScalarFunction TRANSLATE
        Translate scalar function.

      • UNICODE

        public static final ScalarFunction UNICODE
        Unicode scalar function.

      • UNICODECHR

        public static final ScalarFunction UNICODECHR
        Unicodechr scalar function.

      • UPPER

        public static final ScalarFunction UPPER
        Upper scalar function.

      • ADD_DAYS

        public static final ScalarFunction ADD_DAYS
        Add days scalar function.

      • ADD_HOURS

        public static final ScalarFunction ADD_HOURS
        Add hours scalar function.

      • ADD_MINUTES

        public static final ScalarFunction ADD_MINUTES
        Add minutes scalar function.

      • ADD_MONTHS

        public static final ScalarFunction ADD_MONTHS
        Add months scalar function.

      • ADD_SECONDS

        public static final ScalarFunction ADD_SECONDS
        Add seconds scalar function.

      • ADD_WEEKS

        public static final ScalarFunction ADD_WEEKS
        Add weeks scalar function.

      • ADD_YEARS

        public static final ScalarFunction ADD_YEARS
        Add years scalar function.

      • CONVERT_TZ

        public static final ScalarFunction CONVERT_TZ
        Convert tz scalar function.

      • CURRENT_DATE

        public static final ScalarFunction CURRENT_DATE
        Current date scalar function.

      • CURRENT_TIMESTAMP

        public static final ScalarFunction CURRENT_TIMESTAMP
        Current timestamp scalar function.

      • DATE_TRUNC

        public static final ScalarFunction DATE_TRUNC
        Date trunc scalar function.

      • DAYS_BETWEEN

        public static final ScalarFunction DAYS_BETWEEN
        Days between scalar function.

      • DBTIMEZONE

        public static final ScalarFunction DBTIMEZONE
        Dbtimezone scalar function.

      • EXTRACT

        public static final ScalarFunction EXTRACT
        Extract scalar function.

      • FROM_POSIX_TIME

        public static final ScalarFunction FROM_POSIX_TIME
        From posix time scalar function.

      • HOURS_BETWEEN

        public static final ScalarFunction HOURS_BETWEEN
        Hours between scalar function.

      • LOCALTIMESTAMP

        public static final ScalarFunction LOCALTIMESTAMP
        Localtimestamp scalar function.

      • MINUTE

        public static final ScalarFunction MINUTE
        Minute scalar function.

      • MINUTES_BETWEEN

        public static final ScalarFunction MINUTES_BETWEEN
        Minutes between scalar function.

      • MONTH

        public static final ScalarFunction MONTH
        Month scalar function.

      • MONTHS_BETWEEN

        public static final ScalarFunction MONTHS_BETWEEN
        Months between scalar function.

      • NUMTODSINTERVAL

        public static final ScalarFunction NUMTODSINTERVAL
        Numtodsinterval scalar function.

      • NUMTOYMINTERVAL

        public static final ScalarFunction NUMTOYMINTERVAL
        Numtoyminterval scalar function.

      • POSIX_TIME

        public static final ScalarFunction POSIX_TIME
        Posix time scalar function.

      • SECOND

        public static final ScalarFunction SECOND
        Second scalar function.

      • SECONDS_BETWEEN

        public static final ScalarFunction SECONDS_BETWEEN
        Seconds between scalar function.

      • SESSIONTIMEZONE

        public static final ScalarFunction SESSIONTIMEZONE
        Sessiontimezone scalar function.

      • SYSDATE

        public static final ScalarFunction SYSDATE
        Sysdate scalar function.

      • SYSTIMESTAMP

        public static final ScalarFunction SYSTIMESTAMP
        Systimestamp scalar function.

      • YEARS_BETWEEN

        public static final ScalarFunction YEARS_BETWEEN
        Years between scalar function.

      • ST_ENDPOINT

        public static final ScalarFunction ST_ENDPOINT
        St endpoint scalar function.

      • ST_ISCLOSED

        public static final ScalarFunction ST_ISCLOSED
        St isclosed scalar function.

      • ST_ISRING

        public static final ScalarFunction ST_ISRING
        St isring scalar function.

      • ST_LENGTH

        public static final ScalarFunction ST_LENGTH
        St length scalar function.

      • ST_NUMPOINTS

        public static final ScalarFunction ST_NUMPOINTS
        St numpoints scalar function.

      • ST_POINTN

        public static final ScalarFunction ST_POINTN
        St pointn scalar function.

      • ST_STARTPOINT

        public static final ScalarFunction ST_STARTPOINT
        St startpoint scalar function.

      • ST_AREA

        public static final ScalarFunction ST_AREA
        St area scalar function.

      • ST_EXTERIORRING

        public static final ScalarFunction ST_EXTERIORRING
        St exteriorring scalar function.

      • ST_INTERIORRINGN

        public static final ScalarFunction ST_INTERIORRINGN
        St interiorringn scalar function.

      • ST_NUMINTERIORRINGS

        public static final ScalarFunction ST_NUMINTERIORRINGS
        St numinteriorrings scalar function.

      • ST_GEOMETRYN

        public static final ScalarFunction ST_GEOMETRYN
        St geometryn scalar function.

      • ST_NUMGEOMETRIES

        public static final ScalarFunction ST_NUMGEOMETRIES
        St numgeometries scalar function.

      • ST_BOUNDARY

        public static final ScalarFunction ST_BOUNDARY
        St boundary scalar function.

      • ST_BUFFER

        public static final ScalarFunction ST_BUFFER
        St buffer scalar function.

      • ST_CENTROID

        public static final ScalarFunction ST_CENTROID
        St centroid scalar function.

      • ST_CONTAINS

        public static final ScalarFunction ST_CONTAINS
        St contains scalar function.

      • ST_CONVEXHULL

        public static final ScalarFunction ST_CONVEXHULL
        St convexhull scalar function.

      • ST_CROSSES

        public static final ScalarFunction ST_CROSSES
        St crosses scalar function.

      • ST_DIFFERENCE

        public static final ScalarFunction ST_DIFFERENCE
        St difference scalar function.

      • ST_DIMENSION

        public static final ScalarFunction ST_DIMENSION
        St dimension scalar function.

      • ST_DISJOINT

        public static final ScalarFunction ST_DISJOINT
        St disjoint scalar function.

      • ST_DISTANCE

        public static final ScalarFunction ST_DISTANCE
        St distance scalar function.

      • ST_ENVELOPE

        public static final ScalarFunction ST_ENVELOPE
        St envelope scalar function.

      • ST_EQUALS

        public static final ScalarFunction ST_EQUALS
        St equals scalar function.

      • ST_FORCE2D

        public static final ScalarFunction ST_FORCE2D
        St force 2 d scalar function.

      • ST_GEOMETRYTYPE

        public static final ScalarFunction ST_GEOMETRYTYPE
        St geometrytype scalar function.

      • ST_INTERSECTION

        public static final ScalarFunction ST_INTERSECTION
        St intersection scalar function.

      • ST_INTERSECTS

        public static final ScalarFunction ST_INTERSECTS
        St intersects scalar function.

      • ST_ISEMPTY

        public static final ScalarFunction ST_ISEMPTY
        St isempty scalar function.

      • ST_ISSIMPLE

        public static final ScalarFunction ST_ISSIMPLE
        St issimple scalar function.

      • ST_OVERLAPS

        public static final ScalarFunction ST_OVERLAPS
        St overlaps scalar function.

      • ST_SETSRID

        public static final ScalarFunction ST_SETSRID
        St setsrid scalar function.

      • ST_SYMDIFFERENCE

        public static final ScalarFunction ST_SYMDIFFERENCE
        St symdifference scalar function.

      • ST_TOUCHES

        public static final ScalarFunction ST_TOUCHES
        St touches scalar function.

      • ST_TRANSFORM

        public static final ScalarFunction ST_TRANSFORM
        St transform scalar function.

      • ST_UNION

        public static final ScalarFunction ST_UNION
        St union scalar function.

      • ST_WITHIN

        public static final ScalarFunction ST_WITHIN
        St within scalar function.

      • IS_NUMBER

        public static final ScalarFunction IS_NUMBER
        Is number scalar function.

      • IS_BOOLEAN

        public static final ScalarFunction IS_BOOLEAN
        Is boolean scalar function.

      • IS_DATE

        public static final ScalarFunction IS_DATE
        Is date scalar function.

      • IS_DSINTERVAL

        public static final ScalarFunction IS_DSINTERVAL
        Is dsinterval scalar function.

      • IS_YMINTERVAL

        public static final ScalarFunction IS_YMINTERVAL
        Is yminterval scalar function.

      • IS_TIMESTAMP

        public static final ScalarFunction IS_TIMESTAMP
        Is timestamp scalar function.

      • TO_CHAR

        public static final ScalarFunction TO_CHAR
        To char scalar function.

      • TO_DATE

        public static final ScalarFunction TO_DATE
        To date scalar function.

      • TO_DSINTERVAL

        public static final ScalarFunction TO_DSINTERVAL
        To dsinterval scalar function.

      • TO_YMINTERVAL

        public static final ScalarFunction TO_YMINTERVAL
        To yminterval scalar function.

      • TO_NUMBER

        public static final ScalarFunction TO_NUMBER
        To number scalar function.

      • TO_TIMESTAMP

        public static final ScalarFunction TO_TIMESTAMP
        To timestamp scalar function.

      • BIT_AND

        public static final ScalarFunction BIT_AND
        Bit and scalar function.

      • BIT_CHECK

        public static final ScalarFunction BIT_CHECK
        Bit check scalar function.

      • BIT_LROTATE

        public static final ScalarFunction BIT_LROTATE
        Bit lrotate scalar function.

      • BIT_LSHIFT

        public static final ScalarFunction BIT_LSHIFT
        Bit lshift scalar function.

      • BIT_NOT

        public static final ScalarFunction BIT_NOT
        Bit not scalar function.

      • BIT_OR

        public static final ScalarFunction BIT_OR
        Bit or scalar function.

      • BIT_RROTATE

        public static final ScalarFunction BIT_RROTATE
        Bit rrotate scalar function.

      • BIT_RSHIFT

        public static final ScalarFunction BIT_RSHIFT
        Bit rshift scalar function.

      • BIT_SET

        public static final ScalarFunction BIT_SET
        Bit set scalar function.

      • BIT_TO_NUM

        public static final ScalarFunction BIT_TO_NUM
        Bit to num scalar function.

      • BIT_XOR

        public static final ScalarFunction BIT_XOR
        Bit xor scalar function.

      • CURRENT_SCHEMA

        public static final ScalarFunction CURRENT_SCHEMA
        Current schema scalar function.

      • CURRENT_SESSION

        public static final ScalarFunction CURRENT_SESSION
        Current session scalar function.

      • CURRENT_STATEMENT

        public static final ScalarFunction CURRENT_STATEMENT
        Current statement scalar function.

      • CURRENT_USER

        public static final ScalarFunction CURRENT_USER
        Current user scalar function.

      • HASH_MD5

        public static final ScalarFunction HASH_MD5
        Hash md 5 scalar function.

      • HASHTYPE_MD5

        public static final ScalarFunction HASHTYPE_MD5
        Hashtype md 5 scalar function.

      • HASH_SHA1

        public static final ScalarFunction HASH_SHA1
        Hash sha 1 scalar function.

      • HASHTYPE_SHA1

        public static final ScalarFunction HASHTYPE_SHA1
        Hashtype sha 1 scalar function.

      • HASH_SHA256

        public static final ScalarFunction HASH_SHA256
        Hash sha 256 scalar function.

      • HASHTYPE_SHA256

        public static final ScalarFunction HASHTYPE_SHA256
        Hashtype sha 256 scalar function.

      • HASH_SHA512

        public static final ScalarFunction HASH_SHA512
        Hash sha 512 scalar function.

      • HASHTYPE_SHA512

        public static final ScalarFunction HASHTYPE_SHA512
        Hashtype sha 512 scalar function.

      • HASH_TIGER

        public static final ScalarFunction HASH_TIGER
        Hash tiger scalar function.

      • HASHTYPE_TIGER

        public static final ScalarFunction HASHTYPE_TIGER
        Hashtype tiger scalar function.

      • NULLIFZERO

        public static final ScalarFunction NULLIFZERO
        Nullifzero scalar function.

      • SYS_GUID

        public static final ScalarFunction SYS_GUID
        Sys guid scalar function.

      • ZEROIFNULL

        public static final ScalarFunction ZEROIFNULL
        Zeroifnull scalar function.

      • JSON_VALUE

        public static final ScalarFunction JSON_VALUE
        Json value scalar function.

      • SESSION_PARAMETER

        public static final ScalarFunction SESSION_PARAMETER
        Session parameter scalar function.

      • MIN_SCALE

        public static final ScalarFunction MIN_SCALE
        Min scale scalar function.

      • TYPEOF

        public static final ScalarFunction TYPEOF
        Typeof scalar function.

      • CURRENT_CLUSTER

        public static final ScalarFunction CURRENT_CLUSTER
        Current cluster scalar function.

    • 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