The standard set of row-level functions and operators are declared in
SqlStdOperatorTable. Anonymous inner
classes within that table are allowed only for specifying an operator's test
function; if other custom code is needed for an operator, it should be
implemented in a top-level class within this package instead. Operators
which are not row-level (e.g. select and join) should be defined in package
ClassDescriptionAn annotation that is read by
SqlLibraryOperatorTableFactoryto add functions and operators to a library.Deprecated.Use
SqlLibrary.ORACLEas argument.Base class for grouping functions
GROUPING.Base class for time functions such as "LOCALTIME", "LOCALTIME(n)".Definition of the
ANY_VALUEaggregate functions, returning any one of the values which go into it.Definition of the SQL:2003 standard ARRAY query constructor,
ARRAY (<query>).Definition of the SQL:2003 standard ARRAY constructor,
ARRAY [<expr>, ...].
Avgis an aggregator which returns the average of the values which go into it.Deprecated.Base class for functions such as "USER", "CURRENT_ROLE", and "CURRENT_PATH".Concrete implementation of
SqlAggFunction.Defines the BETWEEN operator.Defines the "SYMMETRIC" and "ASYMMETRIC" keywords.Definition of the
BIT_ORaggregate functions, returning the bitwise AND/OR of all non-null input values, or null if none.A
SqlCaseis a node of a parse tree which represents a case statement.An operator describing a
COALESCEfunction.SqlCollectionTableOperator is the "table function derived table" operator.SqlColumnListConstructor defines the non-standard constructor used to pass a COLUMN_LIST parameter to a UDX.The
CONVERTfunction, which converts a string from one character set to another.Definition of the SQL
Covaris an aggregator which returns the Covariance of the values which go into it.Deprecated.The
CURRENT_DATEfunction.SqlCursorConstructor defines the non-standard CURSOR(<query>) constructor.SqlDatePartFunction represents the SQL:1999 standard
DAYfunctions.Operator that adds an INTERVAL to a DATETIME.A special operator for the subtraction of two DATETIMEs.The dot operator
., used to access a field of a record.The SQL
LAST_VALUEaggregate functions return the first or the last value in a list of values that are input to the function.Definition of the "FLOOR" and "CEIL" built-in SQL functions.
HISTOGRAMis the base operator that supports the Histogram MIN/MAX aggregate functions.Definition of the SQL
INoperator, which tests for a value's membership in a sub-query or a list of values.Contains internal operators.Interval expression.The item operator
[ ... ], used to access a given element of an array, map or struct.The
JSON_LENGTHfunction.Definition of the
JSON_SETJSON Modify functions.The
JSON_TYPEfunction.The JSON value expression operator that indicates that the value expression should be parsed as JSON.The
LAGaggregate functions return the value of given expression evaluated at given offset.A library is a collection of SQL functions and operators.Defines functions and operators that are not part of standard SQL but belong to one or more other dialects of SQL.Factory that creates operator tables that consist of functions and operators for particular named libraries.An operator describing the
LITERAL_AGGaggregate function.Internal operator, by which the parser represents a continued string literal.Definition of the MAP query constructor,
MAP (<query>).Definition of the MAP constructor,
MAP [<key>, <value>, ...].Definition of the
MAXaggregate functions, returning the returns the smallest/largest of the values which go into it.Base class for binary operators such as addition, subtraction, and multiplication which are monotonic for the patterns
m op cand
c op mwhere m is any monotonic expression and c is a constant.Base class for unary operators such as FLOOR/CEIL which are monotonic for monotonic inputs.Multiset MEMBER OF.Definition of the SQL:2003 standard MULTISET query constructor,
MULTISET (<query>).An operator which performs set operations on multisets, such as "MULTISET UNION ALL".Definition of the SQL:2003 standard MULTISET constructor,
MULTISET [<expr>, ...].SqlNewOperator represents an SQL
new specificationsuch as
NEW UDT(1, 2).
NTH_VALUEwindowed aggregate function returns the value of an expression evaluated at the
nth row of the window frame.
NTILEaggregate function return the value of given expression evaluated at given offset.The
NULLIFfunction.SqlOverlapsOperator represents the SQL:1999 standard
POSITIONfunction.An operator describing the
~operator.Definition of the SQL
RAND_INTEGERfunction.The REGEXP_REPLACE(source_string, pattern, replacement [, pos, occurrence, match_type]) searches for a regular expression pattern and replaces every occurrence of the pattern with the specified string.Definition of the SQL
REGR_COUNTaggregation function.SqlRowOperator represents the special ROW constructor.Operator that returns the current or next value of a sequence.
SINGLE_VALUEaggregate function returns the input value if there is only one value in the input; Otherwise it triggers a run-time error.Utilities for spatial type functions.Returns the geometries of a geometry.Returns the points or rectangles in a grid that covers a given geometry.Implementation of
SqlOperatorTablecontaining the standard operators and functions.Base class for string functions such as "USER", "CURRENT_ROLE", and "CURRENT_PATH".Definition of the "SUBSTRING" builtin SQL function.
Sumis an aggregator which returns the sum of the values which go into it.
Sum0is an aggregator which returns the sum of the values which go into it like
Sum.An internal operator that throws an exception.The
TIMESTAMPADDfunction, which adds an interval to a datetime (TIMESTAMP, TIME or DATE).Definition of the "TRANSLATE" built-in SQL function that takes 3 arguments.Definition of the "TRIM" builtin SQL function.Defines the enumerated values "LEADING", "TRAILING", "BOTH".