Enum ExasolScalarFunction
- java.lang.Object
-
- java.lang.Enum<ExasolScalarFunction>
-
- com.exasol.sql.expression.function.exasol.ExasolScalarFunction
-
- All Implemented Interfaces:
FunctionName
,Serializable
,Comparable<ExasolScalarFunction>
public enum ExasolScalarFunction extends Enum<ExasolScalarFunction> implements FunctionName
This class is a list of Scalar Functions that the Exasol database supports. Currently unsupported functions: POSITION, DATE_TRUNC, EXTRACT, CAST, CONVERT, CASE, SPACE, Functions for Hierarchical Queries. Keywords inside function's body are also not supported. See github issue # 68.
-
-
Enum Constant Summary
Enum Constants Enum Constant Description ABS
Absolute value of a numberACOS
ArccosineADD_DAYS
Add daysADD_HOURS
Add hoursADD_MINUTES
Add minutesADD_MONTHS
Add monthsADD_SECONDS
Add secondsADD_WEEKS
Add weeksADD_YEARS
Add yearsASCII
ASCII code of characterASIN
ArcsineATAN
ArctangensATAN2
Arctanges of two numbers (instead of fration)BIT_AND
Bitwise andBIT_CHECK
Check bit setBIT_LENGTH
String size in bitsBIT_LROTATE
Rotate leftBIT_LSHIFT
Shift leftBIT_NOT
Bitwise notBIT_OR
Bitwise orBIT_RROTATE
Rotate rightBIT_RSHIFT
Shift rightBIT_SET
Set bitBIT_TO_NUM
Bitmask to numberBIT_XOR
Bitwise exclusive orCEIL
CeilingCHAR
Character for numberCHARACTER_LENGTH
String size in charactersCOALESCE
First non-null valueCOLOGNE_PHONETIC
Phonetic representation of a stringCONCAT
String concatenationCONVERT_TZ
Convert timezoneCOS
CosineCOSH
Hyperbolic cosineCOT
CotangensCURRENT_DATE
Current dateCURRENT_SCHEMA
Current database schemaCURRENT_SESSION
Current sessionCURRENT_STATEMENT
Current statementCURRENT_TIMESTAMP
Current timestampCURRENT_USER
Current userDAY
Day part of dateDAYS_BETWEEN
Days between two datesDBTIMEZONE
Database-wide TimezoneDECODE
String-based case selectionDEGREES
Radians to degreesDIV
Integer divisionDUMP
String dump in various notationsEDIT_DISTANCE
Edit distance of two stringsEXP
ExponentFLOOR
FloorFROM_POSIX_TIME
Posix time to timestampGREATEST
Greatest valueHASH_MD5
MD5 hashHASH_SHA
SHA1 hashHASH_SHA256
SHA256 hashHASH_SHA512
SHA512 hashHASH_TIGER
Tiger hashHOUR
Hour part of a date / timeHOURS_BETWEEN
Hours betweenINITCAP
Capitalize first letter of each wordINSERT
Insert string into other stringINSTR
Find occurrence in stringIPROC
Data node numberIS_BOOLEAN
Is a booleanIS_DATE
Is a dateIS_DSINTERVAL
Is an interval with second precisionIS_NUMBER
Is a numberIS_TIMESTAMP
Is a timestampIS_YMINTERVAL
Is an interval with month precisionLCASE
Lower caseLEAST
Least valueLEFT
Left part of stringLENGTH
String length in characters (differs from bytes for UTF)LN
Logarithm to base eLOCALTIMESTAMP
Timestamp in local timeLOCATE
Find position in stringLOG
Logarithm with user-defined baseLOG10
Logarithm to base 10LOG2
Logrithm to base 2LOWER
Lower caseLPAD
Pad leftLTRIM
Trim leftMID
Take a part from the mid of the stringMINUTE
Minute part of a date / timeMINUTES_BETWEEN
Minutes betweenMOD
ModuloMONTH
Month part of a dateMONTHS_BETWEEN
Months between two datesNOW
Current timestampNPROC
Number of cluster nodesNULLIF
Null ifNULLIFZERO
Null if zeroNUMTODSINTERVAL
Number to days-to-second intervalNUMTOYMINTERVAL
Number to years-to-month intervalNVL
Replace null with expressionNVL2
Replace null with expression.OCTET_LENGTH
String length in bytesPI
PiPOSIX_TIME
Seconds since EpochPOWER
PowerRADIANS
Degrees to radiansRANDOM
Random numberREGEXP_INSTR
Find occurrence of regular expression in stringREGEXP_REPLACE
Replace occurrence of regular expression in stringREGEXP_SUBSTR
Return substring that matches regular expressionREPEAT
Repeat string sequenceREPLACE
Replace substringREVERSE
Reverse stringRIGHT
Right part of a stringROUND
RoundROWID
Row IDROWNUM
Row counterRPAD
Pad rightRTRIM
Trim rightSCOPE_USER
Scope userSECOND
Second part of a date / timeSECONDS_BETWEEN
Seconds between two dates / timesSESSIONTIMEZONE
Session timezoneSIGN
SignSIN
SineSINH
Hyperbolic sineSOUNDEX
Sounds likeSQRT
Square rootST_AREA
Area of (multi-)polygonST_BOUNDARY
Geometric boundaryST_BUFFER
Points of maximal distanceST_CENTROID
Center of massST_CONTAINS
Object fully contains another objectST_CONVEXHULL
Convex hullST_CROSSES
Object crosses another objectST_DIFFERENCE
DifferenceST_DIMENSION
Dimmension of object: Points / Lines / PoligonsST_DISJOINT
Object disjoint of another objectST_DISTANCE
Minimal distance between two objectsST_ENDPOINT
Endpoint of lineST_ENVELOPE
Smallest rectangle containing objectST_EQUALS
Objects equalST_EXTERIORRING
Outer ring of objectST_FORCE2D
Turn to 2D objectST_GEOMETRYN
The n-th object of a GeometryCollectionST_GEOMETRYTYPE
Type as stringST_INTERIORRINGN
Inner ringST_INTERSECTION
Intersection of two objectsST_INTERSECTS
Objects intersectST_ISCLOSED
Object is closedST_ISEMPTY
Empty setST_ISRING
Start point = end pointST_ISSIMPLE
Simple objectST_LENGTH
LengthST_NUMGEOMETRIES
Number of objects in collection of geometry objectsST_NUMINTERIORRINGS
Number of holes within a PolygonST_NUMPOINTS
Points in line stringST_OVERLAPS
Objects overlapST_POINTN
n-th pointST_SETSRID
Set SRIDST_STARTPOINT
Start pointST_SYMDIFFERENCE
Symmetric differenceST_TOUCHES
Object touches another objectST_TRANSFORM
Coordinate transformationST_UNION
Union of two objectsST_WITHIN
Object fully contained in another objectST_X
X coordinate of pointST_Y
Y coordinate of pointSUBSTR
SubstringSYS_GUID
Unique system wide IDSYSDATE
Current dateSYSTIMESTAMP
Current timestampTAN
TangensTANH
Hyperbolic tangensTO_CHAR
Convert to character stringTO_DATE
Convert to dateTO_DSINTERVAL
Convert to interval with second precisionTO_NUMBER
Convert to numberTO_YMINTERVAL
Convert to timestamp +/ TO_TIMESTAMP, /** Convert to interval with month precisionTRANSLATE
Replace characters in stringTRIM
Remove surrounding white spacesTRUNC
Trim decimal placesUCASE
Upper caseUNICODE
Numeric unicode representation of characterUNICODECHR
Character for numeric unicodeUPPER
Upper caseUSER
Current userVALUE2PROC
Number of the node a value is onWEEK
Week part of a dateYEAR
Year part of a dateYEARS_BETWEEN
Years between two datesZEROIFNULL
Zero if null
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static ExasolScalarFunction
valueOf(String name)
Returns the enum constant of this type with the specified name.static ExasolScalarFunction[]
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 interface com.exasol.sql.expression.function.FunctionName
name
-
-
-
-
Enum Constant Detail
-
ABS
public static final ExasolScalarFunction ABS
Absolute value of a number
-
ACOS
public static final ExasolScalarFunction ACOS
Arccosine
-
ASIN
public static final ExasolScalarFunction ASIN
Arcsine
-
ATAN
public static final ExasolScalarFunction ATAN
Arctangens
-
ATAN2
public static final ExasolScalarFunction ATAN2
Arctanges of two numbers (instead of fration)
-
CEIL
public static final ExasolScalarFunction CEIL
Ceiling
-
COS
public static final ExasolScalarFunction COS
Cosine
-
COSH
public static final ExasolScalarFunction COSH
Hyperbolic cosine
-
COT
public static final ExasolScalarFunction COT
Cotangens
-
DEGREES
public static final ExasolScalarFunction DEGREES
Radians to degrees
-
DIV
public static final ExasolScalarFunction DIV
Integer division
-
EXP
public static final ExasolScalarFunction EXP
Exponent
-
FLOOR
public static final ExasolScalarFunction FLOOR
Floor
-
LN
public static final ExasolScalarFunction LN
Logarithm to base e
-
LOG
public static final ExasolScalarFunction LOG
Logarithm with user-defined base
-
LOG10
public static final ExasolScalarFunction LOG10
Logarithm to base 10
-
LOG2
public static final ExasolScalarFunction LOG2
Logrithm to base 2
-
MOD
public static final ExasolScalarFunction MOD
Modulo
-
PI
public static final ExasolScalarFunction PI
Pi
-
POWER
public static final ExasolScalarFunction POWER
Power
-
RADIANS
public static final ExasolScalarFunction RADIANS
Degrees to radians
-
RANDOM
public static final ExasolScalarFunction RANDOM
Random number
-
ROUND
public static final ExasolScalarFunction ROUND
Round
-
SIGN
public static final ExasolScalarFunction SIGN
Sign
-
SIN
public static final ExasolScalarFunction SIN
Sine
-
SINH
public static final ExasolScalarFunction SINH
Hyperbolic sine
-
SQRT
public static final ExasolScalarFunction SQRT
Square root
-
TAN
public static final ExasolScalarFunction TAN
Tangens
-
TANH
public static final ExasolScalarFunction TANH
Hyperbolic tangens
-
TRUNC
public static final ExasolScalarFunction TRUNC
Trim decimal places
-
ASCII
public static final ExasolScalarFunction ASCII
ASCII code of character
-
BIT_LENGTH
public static final ExasolScalarFunction BIT_LENGTH
String size in bits
-
CHARACTER_LENGTH
public static final ExasolScalarFunction CHARACTER_LENGTH
String size in characters
-
CHAR
public static final ExasolScalarFunction CHAR
Character for number
-
COLOGNE_PHONETIC
public static final ExasolScalarFunction COLOGNE_PHONETIC
Phonetic representation of a string
-
CONCAT
public static final ExasolScalarFunction CONCAT
String concatenation
-
DUMP
public static final ExasolScalarFunction DUMP
String dump in various notations
-
EDIT_DISTANCE
public static final ExasolScalarFunction EDIT_DISTANCE
Edit distance of two strings
-
INITCAP
public static final ExasolScalarFunction INITCAP
Capitalize first letter of each word
-
INSERT
public static final ExasolScalarFunction INSERT
Insert string into other string
-
INSTR
public static final ExasolScalarFunction INSTR
Find occurrence in string
-
LCASE
public static final ExasolScalarFunction LCASE
Lower case
-
LEFT
public static final ExasolScalarFunction LEFT
Left part of string
-
LENGTH
public static final ExasolScalarFunction LENGTH
String length in characters (differs from bytes for UTF)
-
LOCATE
public static final ExasolScalarFunction LOCATE
Find position in string
-
LOWER
public static final ExasolScalarFunction LOWER
Lower case
-
LPAD
public static final ExasolScalarFunction LPAD
Pad left
-
LTRIM
public static final ExasolScalarFunction LTRIM
Trim left
-
MID
public static final ExasolScalarFunction MID
Take a part from the mid of the string
-
OCTET_LENGTH
public static final ExasolScalarFunction OCTET_LENGTH
String length in bytes
-
REGEXP_INSTR
public static final ExasolScalarFunction REGEXP_INSTR
Find occurrence of regular expression in string
-
REGEXP_REPLACE
public static final ExasolScalarFunction REGEXP_REPLACE
Replace occurrence of regular expression in string
-
REGEXP_SUBSTR
public static final ExasolScalarFunction REGEXP_SUBSTR
Return substring that matches regular expression
-
REPEAT
public static final ExasolScalarFunction REPEAT
Repeat string sequence
-
REPLACE
public static final ExasolScalarFunction REPLACE
Replace substring
-
REVERSE
public static final ExasolScalarFunction REVERSE
Reverse string
-
RIGHT
public static final ExasolScalarFunction RIGHT
Right part of a string
-
RPAD
public static final ExasolScalarFunction RPAD
Pad right
-
RTRIM
public static final ExasolScalarFunction RTRIM
Trim right
-
SOUNDEX
public static final ExasolScalarFunction SOUNDEX
Sounds like
-
SUBSTR
public static final ExasolScalarFunction SUBSTR
Substring
-
TRANSLATE
public static final ExasolScalarFunction TRANSLATE
Replace characters in string
-
TRIM
public static final ExasolScalarFunction TRIM
Remove surrounding white spaces
-
UCASE
public static final ExasolScalarFunction UCASE
Upper case
-
UNICODE
public static final ExasolScalarFunction UNICODE
Numeric unicode representation of character
-
UNICODECHR
public static final ExasolScalarFunction UNICODECHR
Character for numeric unicode
-
UPPER
public static final ExasolScalarFunction UPPER
Upper case
-
ADD_DAYS
public static final ExasolScalarFunction ADD_DAYS
Add days
-
ADD_HOURS
public static final ExasolScalarFunction ADD_HOURS
Add hours
-
ADD_MINUTES
public static final ExasolScalarFunction ADD_MINUTES
Add minutes
-
ADD_MONTHS
public static final ExasolScalarFunction ADD_MONTHS
Add months
-
ADD_SECONDS
public static final ExasolScalarFunction ADD_SECONDS
Add seconds
-
ADD_WEEKS
public static final ExasolScalarFunction ADD_WEEKS
Add weeks
-
ADD_YEARS
public static final ExasolScalarFunction ADD_YEARS
Add years
-
CONVERT_TZ
public static final ExasolScalarFunction CONVERT_TZ
Convert timezone
-
CURRENT_DATE
public static final ExasolScalarFunction CURRENT_DATE
Current date
-
CURRENT_TIMESTAMP
public static final ExasolScalarFunction CURRENT_TIMESTAMP
Current timestamp
-
DAY
public static final ExasolScalarFunction DAY
Day part of date
-
DAYS_BETWEEN
public static final ExasolScalarFunction DAYS_BETWEEN
Days between two dates
-
DBTIMEZONE
public static final ExasolScalarFunction DBTIMEZONE
Database-wide Timezone
-
FROM_POSIX_TIME
public static final ExasolScalarFunction FROM_POSIX_TIME
Posix time to timestamp
-
HOUR
public static final ExasolScalarFunction HOUR
Hour part of a date / time
-
HOURS_BETWEEN
public static final ExasolScalarFunction HOURS_BETWEEN
Hours between
-
LOCALTIMESTAMP
public static final ExasolScalarFunction LOCALTIMESTAMP
Timestamp in local time
-
MINUTE
public static final ExasolScalarFunction MINUTE
Minute part of a date / time
-
MINUTES_BETWEEN
public static final ExasolScalarFunction MINUTES_BETWEEN
Minutes between
-
MONTH
public static final ExasolScalarFunction MONTH
Month part of a date
-
MONTHS_BETWEEN
public static final ExasolScalarFunction MONTHS_BETWEEN
Months between two dates
-
NOW
public static final ExasolScalarFunction NOW
Current timestamp
-
NUMTODSINTERVAL
public static final ExasolScalarFunction NUMTODSINTERVAL
Number to days-to-second interval
-
NUMTOYMINTERVAL
public static final ExasolScalarFunction NUMTOYMINTERVAL
Number to years-to-month interval
-
POSIX_TIME
public static final ExasolScalarFunction POSIX_TIME
Seconds since Epoch
-
SECOND
public static final ExasolScalarFunction SECOND
Second part of a date / time
-
SECONDS_BETWEEN
public static final ExasolScalarFunction SECONDS_BETWEEN
Seconds between two dates / times
-
SESSIONTIMEZONE
public static final ExasolScalarFunction SESSIONTIMEZONE
Session timezone
-
SYSDATE
public static final ExasolScalarFunction SYSDATE
Current date
-
SYSTIMESTAMP
public static final ExasolScalarFunction SYSTIMESTAMP
Current timestamp
-
WEEK
public static final ExasolScalarFunction WEEK
Week part of a date
-
YEAR
public static final ExasolScalarFunction YEAR
Year part of a date
-
YEARS_BETWEEN
public static final ExasolScalarFunction YEARS_BETWEEN
Years between two dates
-
ST_AREA
public static final ExasolScalarFunction ST_AREA
Area of (multi-)polygon
-
ST_BOUNDARY
public static final ExasolScalarFunction ST_BOUNDARY
Geometric boundary
-
ST_BUFFER
public static final ExasolScalarFunction ST_BUFFER
Points of maximal distance
-
ST_CENTROID
public static final ExasolScalarFunction ST_CENTROID
Center of mass
-
ST_CONTAINS
public static final ExasolScalarFunction ST_CONTAINS
Object fully contains another object
-
ST_CONVEXHULL
public static final ExasolScalarFunction ST_CONVEXHULL
Convex hull
-
ST_CROSSES
public static final ExasolScalarFunction ST_CROSSES
Object crosses another object
-
ST_DIFFERENCE
public static final ExasolScalarFunction ST_DIFFERENCE
Difference
-
ST_DIMENSION
public static final ExasolScalarFunction ST_DIMENSION
Dimmension of object: Points / Lines / Poligons
-
ST_DISJOINT
public static final ExasolScalarFunction ST_DISJOINT
Object disjoint of another object
-
ST_DISTANCE
public static final ExasolScalarFunction ST_DISTANCE
Minimal distance between two objects
-
ST_ENDPOINT
public static final ExasolScalarFunction ST_ENDPOINT
Endpoint of line
-
ST_ENVELOPE
public static final ExasolScalarFunction ST_ENVELOPE
Smallest rectangle containing object
-
ST_EQUALS
public static final ExasolScalarFunction ST_EQUALS
Objects equal
-
ST_EXTERIORRING
public static final ExasolScalarFunction ST_EXTERIORRING
Outer ring of object
-
ST_FORCE2D
public static final ExasolScalarFunction ST_FORCE2D
Turn to 2D object
-
ST_GEOMETRYN
public static final ExasolScalarFunction ST_GEOMETRYN
The n-th object of a GeometryCollection
-
ST_GEOMETRYTYPE
public static final ExasolScalarFunction ST_GEOMETRYTYPE
Type as string
-
ST_INTERIORRINGN
public static final ExasolScalarFunction ST_INTERIORRINGN
Inner ring
-
ST_INTERSECTION
public static final ExasolScalarFunction ST_INTERSECTION
Intersection of two objects
-
ST_INTERSECTS
public static final ExasolScalarFunction ST_INTERSECTS
Objects intersect
-
ST_ISCLOSED
public static final ExasolScalarFunction ST_ISCLOSED
Object is closed
-
ST_ISEMPTY
public static final ExasolScalarFunction ST_ISEMPTY
Empty set
-
ST_ISRING
public static final ExasolScalarFunction ST_ISRING
Start point = end point
-
ST_ISSIMPLE
public static final ExasolScalarFunction ST_ISSIMPLE
Simple object
-
ST_LENGTH
public static final ExasolScalarFunction ST_LENGTH
Length
-
ST_NUMGEOMETRIES
public static final ExasolScalarFunction ST_NUMGEOMETRIES
Number of objects in collection of geometry objects
-
ST_NUMINTERIORRINGS
public static final ExasolScalarFunction ST_NUMINTERIORRINGS
Number of holes within a Polygon
-
ST_NUMPOINTS
public static final ExasolScalarFunction ST_NUMPOINTS
Points in line string
-
ST_OVERLAPS
public static final ExasolScalarFunction ST_OVERLAPS
Objects overlap
-
ST_SETSRID
public static final ExasolScalarFunction ST_SETSRID
Set SRID
-
ST_POINTN
public static final ExasolScalarFunction ST_POINTN
n-th point
-
ST_STARTPOINT
public static final ExasolScalarFunction ST_STARTPOINT
Start point
-
ST_SYMDIFFERENCE
public static final ExasolScalarFunction ST_SYMDIFFERENCE
Symmetric difference
-
ST_TOUCHES
public static final ExasolScalarFunction ST_TOUCHES
Object touches another object
-
ST_TRANSFORM
public static final ExasolScalarFunction ST_TRANSFORM
Coordinate transformation
-
ST_UNION
public static final ExasolScalarFunction ST_UNION
Union of two objects
-
ST_WITHIN
public static final ExasolScalarFunction ST_WITHIN
Object fully contained in another object
-
ST_X
public static final ExasolScalarFunction ST_X
X coordinate of point
-
ST_Y
public static final ExasolScalarFunction ST_Y
Y coordinate of point
-
BIT_AND
public static final ExasolScalarFunction BIT_AND
Bitwise and
-
BIT_CHECK
public static final ExasolScalarFunction BIT_CHECK
Check bit set
-
BIT_LROTATE
public static final ExasolScalarFunction BIT_LROTATE
Rotate left
-
BIT_LSHIFT
public static final ExasolScalarFunction BIT_LSHIFT
Shift left
-
BIT_NOT
public static final ExasolScalarFunction BIT_NOT
Bitwise not
-
BIT_OR
public static final ExasolScalarFunction BIT_OR
Bitwise or
-
BIT_RROTATE
public static final ExasolScalarFunction BIT_RROTATE
Rotate right
-
BIT_RSHIFT
public static final ExasolScalarFunction BIT_RSHIFT
Shift right
-
BIT_SET
public static final ExasolScalarFunction BIT_SET
Set bit
-
BIT_TO_NUM
public static final ExasolScalarFunction BIT_TO_NUM
Bitmask to number
-
BIT_XOR
public static final ExasolScalarFunction BIT_XOR
Bitwise exclusive or
-
IS_NUMBER
public static final ExasolScalarFunction IS_NUMBER
Is a number
-
IS_DATE
public static final ExasolScalarFunction IS_DATE
Is a date
-
IS_TIMESTAMP
public static final ExasolScalarFunction IS_TIMESTAMP
Is a timestamp
-
IS_BOOLEAN
public static final ExasolScalarFunction IS_BOOLEAN
Is a boolean
-
IS_DSINTERVAL
public static final ExasolScalarFunction IS_DSINTERVAL
Is an interval with second precision
-
IS_YMINTERVAL
public static final ExasolScalarFunction IS_YMINTERVAL
Is an interval with month precision
-
TO_CHAR
public static final ExasolScalarFunction TO_CHAR
Convert to character string
-
TO_DATE
public static final ExasolScalarFunction TO_DATE
Convert to date
-
TO_DSINTERVAL
public static final ExasolScalarFunction TO_DSINTERVAL
Convert to interval with second precision
-
TO_NUMBER
public static final ExasolScalarFunction TO_NUMBER
Convert to number
-
TO_YMINTERVAL
public static final ExasolScalarFunction TO_YMINTERVAL
Convert to timestamp +/ TO_TIMESTAMP, /** Convert to interval with month precision
-
COALESCE
public static final ExasolScalarFunction COALESCE
First non-null value
-
CURRENT_SCHEMA
public static final ExasolScalarFunction CURRENT_SCHEMA
Current database schema
-
CURRENT_SESSION
public static final ExasolScalarFunction CURRENT_SESSION
Current session
-
CURRENT_STATEMENT
public static final ExasolScalarFunction CURRENT_STATEMENT
Current statement
-
CURRENT_USER
public static final ExasolScalarFunction CURRENT_USER
Current user
-
DECODE
public static final ExasolScalarFunction DECODE
String-based case selection
-
GREATEST
public static final ExasolScalarFunction GREATEST
Greatest value
-
HASH_MD5
public static final ExasolScalarFunction HASH_MD5
MD5 hash
-
HASH_SHA
public static final ExasolScalarFunction HASH_SHA
SHA1 hash
-
HASH_SHA256
public static final ExasolScalarFunction HASH_SHA256
SHA256 hash
-
HASH_SHA512
public static final ExasolScalarFunction HASH_SHA512
SHA512 hash
-
HASH_TIGER
public static final ExasolScalarFunction HASH_TIGER
Tiger hash
-
IPROC
public static final ExasolScalarFunction IPROC
Data node number
-
LEAST
public static final ExasolScalarFunction LEAST
Least value
-
NULLIF
public static final ExasolScalarFunction NULLIF
Null if
-
NULLIFZERO
public static final ExasolScalarFunction NULLIFZERO
Null if zero
-
NPROC
public static final ExasolScalarFunction NPROC
Number of cluster nodes
-
NVL
public static final ExasolScalarFunction NVL
Replace null with expression
-
NVL2
public static final ExasolScalarFunction NVL2
Replace null with expression. Return other expression if not null
-
ROWNUM
public static final ExasolScalarFunction ROWNUM
Row counter
-
ROWID
public static final ExasolScalarFunction ROWID
Row ID
-
SCOPE_USER
public static final ExasolScalarFunction SCOPE_USER
Scope user
-
SYS_GUID
public static final ExasolScalarFunction SYS_GUID
Unique system wide ID
-
USER
public static final ExasolScalarFunction USER
Current user
-
VALUE2PROC
public static final ExasolScalarFunction VALUE2PROC
Number of the node a value is on
-
ZEROIFNULL
public static final ExasolScalarFunction ZEROIFNULL
Zero if null
-
-
Method Detail
-
values
public static ExasolScalarFunction[] 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 (ExasolScalarFunction c : ExasolScalarFunction.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
public static ExasolScalarFunction 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 nameNullPointerException
- if the argument is null
-
-