|
|||||||||||
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 | |
AggregateBigDecimalFunction | |
AndFunction | |
ArithmeticFunction | |
AsciiFunction | |
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. |
BaseBooleanBranchFunction | |
BaseFunction | An abstract base ConcreteFunction implementation. |
BitAndFunction | |
BitOrFunction | |
CastAsFunction | ANSI style Cast As Function function : CAST( {id|expr} AS type) |
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. |
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, timestamp) |
DateToCharFunction | Syntax: DateToChar( date-expr, 'format-string' ) |
DifferenceFunction | |
DivideFunction | |
EqualFunction | |
ExistsFunction | |
FunctionIdentifier | A Selectable representing an unresolved Function . |
GreaterThanFunction | |
GreaterThanOrEqualFunction | |
IfThenFunction | IFTHEN(condition value) : returns value if condition
evalates to true; else, it returns null. |
InFunction | |
InStringFunction | |
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 boolean that indicates whether first string matches the regular
expression represented by the second string |
MaxFunction | |
MinFunction | |
ModFunction | |
MultiplyFunction | |
NotEqualFunction | |
NotExistsFunction | |
NotFunction | |
NotInFunction | |
NowFunction | |
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 | |
SubstringFunction | Syntax: SUBSTRING(str, m [,n]) -- m is one(1) based index.) |
SubtractFunction | |
SumFunction | |
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 |