|
||||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
Function
implementations.
See:
Description
Interface Summary | |
---|---|
AggregateFunction | An aggregate function, which evalutes a collection of
Row s. |
ConcreteFunction | An executable Function , as opposed to a FunctionIdentifier . |
ScalarFunction | A ConcreteFunction that evaluates a single
Row . |
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 ConcreteFunction implementation. |
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 boolean that
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 Type integer representing the
length of the input string . |
LessThanFunction | |
LessThanOrEqualFunction | |
LikeToRegexpFunction | |
Log10Function | |
LowerFunction | LOWER(string): returns a string containing 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
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 string representing the upper
case version of the input string . |
Function
implementations.
|
||||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |