| Class Summary |
|---|
| ABSFunction | |
| AddFunction | |
| AndFunction | |
| ArithmeticFunction | |
| AsciiFunction |
Returns the Integer value of the left most char of the String
|
| AverageFunction | |
| Base64DecodeFunction |
BASE64DECODE(string): returns a byte array representing the Base64 decoded
value of the given string .
|
| Base64EncodeFunction |
BASE64ENCODE(byte[]): returns a string representing the Base64 encoded
value of the given byte[] or Blob.
|
| BaseAggregateFunction | |
| BaseBooleanBranchFunction | |
| BaseFunction |
An abstract base ConcreteFunctionimplementation.
|
| BaseRegExpFunction | |
| BitAndFunction | |
| BitOrFunction | |
| CastAsFunction |
ANSI style CAST...AS Function function : CAST( {id|expr} AS type[(precision[,scale])] )
|
| CharFunction |
CHAR(number): returns the character
representing the unicode value number .
|
| CharToDateFunction |
Syntax: CharToDate( date-string, 'format-literal' )
|
| CoalesceFunction |
COALESCE([value]+): returns the first non-null value in the
argument list.
|
| ComparableAggregateFunction | |
| ComparisonFunction | |
| ConcatFunction |
CONCAT(string [, string]*): concatenates one or more
strings.
|
| ContainsFunction |
CONTAINS(string, string): returns a booleanthat
indicates whether the second string is a substring of the first.
|
| CountFunction |
COUNT: an aggregate function returning the number of rows.
|
| DateAddFunction |
Syntax: DateAdd(interval_type, interval, timestamp)
|
| DateDiffFunction |
Syntax: DATEDIFF(interval_type, timestamp1, timestamp2)
|
| DatePartFunction |
Syntax: DatePart(date-part, date-src) or EXTRACT(date-part FROM date-src)
|
| DateToCharFunction |
Syntax: DateToChar( date-expr, 'format-string' )
|
| DifferenceFunction | |
| DivideFunction | |
| EqualFunction | |
| ExistsFunction | |
| FunctionIdentifier |
A Selectable representing an unresolved Function.
|
| GreaterThanFunction | |
| GreaterThanOrEqualFunction | |
| HexFunction | |
| IfThenFunction |
IFTHEN(condition value): returns value if condition
evalates to true; else, it returns null.
|
| InFunction | |
| InStringFunction |
INSTR(str,substr): Returns the position of the first occurrence of substring substr in
string str.
|
| IsNotNullFunction | |
| IsNullFunction | |
| IsValidDateTimeFunction |
Function to test whether the given String expression is in the same format as the given
date format expression.
|
| LengthFunction |
Length(string): returns a Integer Type integerrepresenting the
length of the input string .
|
| LessThanFunction | |
| LessThanOrEqualFunction | |
| LikeToRegexpFunction | |
| Log10Function | |
| LowerFunction |
LOWER(string): returns a stringcontaining the lower
case version of the input string .
|
| LPadFunction | |
| LTrimFunction | |
| MatchesFunction |
MATCHES(string, string): returns a BooleanTypeboolean that
indicates whether first string matches the regular expression Pattern pattern
represented by the second string.
|
| MaxFunction | |
| MinFunction | |
| ModFunction | |
| MultiplyFunction | |
| NotEqualFunction | |
| NotFunction | |
| NotInFunction | |
| NowFunction | |
| NullIfFunction |
The NULLIF function returns a null value if the arguments are equal, otherwise it
returns the value of the first argument.
|
| OrFunction | |
| ReplaceFunction | |
| RoundFunction | |
| RowNumFunction |
Returns an one-based index indicating the order in which a row was selected from a
table, join, etc.
|
| RPadFunction | |
| RTrimFunction | |
| SignFunction |
Returns an indicator of the sign of the given double value. |
| SoundexFunction | |
| SoundsLikeFunction | |
| SpaceFunction |
Returns a string filled with a given number of spaces.
|
| SubstringFunction |
Syntax: SUBSTRING(str, m [,n]) -- m is one(1) based index.)
|
| SubtractFunction | |
| SumFunction | |
| TrimFunction |
TRIM ( [LEADING| TRAILING| BOTH] [ trim-character ] FROM ] trim-source) function
|
| TruncateFunction | |
| UpperFunction |
UPPER(string): returns a stringrepresenting the upper
case version of the input string .
|