Package wt.query
Class AnalyticFunction
java.lang.Object
wt.query.SQLFunction
wt.query.AnalyticFunction
- All Implemented Interfaces:
Externalizable,Serializable,ColumnExpression,wt.query.Expression,OrderByExpression,RelationalExpression
Supported API: true
Extendable: false
- See Also:
-
Field Summary
Fields inherited from class wt.query.SQLFunction
ABS, ADD, AVERAGE, BITAND, CEIL, CONCAT, COUNT, DECODE, DIVIDE, FLOOR, GET_DAY, GET_HOURS, GET_MINUTES, GET_MONTH, GET_SECONDS, GET_YEAR, IN_STRING, LOG, LOWER, LTRIM, MAXIMUM, MINIMUM, MOD, MULTIPLY, NLSSORT, NULL_VALUE, ROUND, RTRIM, SIGN, SOUNDEX, STDDEV, SUB_STRING, SUBTRACT, SUM, TO_CHAR, TO_NUMBER, TRUNCATE, UPPERFields inherited from interface wt.query.ColumnExpression
COLUMN_ALIAS -
Method Summary
Modifier and TypeMethodDescriptionstatic AnalyticFunctionnewAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression[] a_partitionColumns) Constructs a new AnalyticFunction.static AnalyticFunctionnewAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression[] a_partitionColumns, OrderBy[] a_orderBys) Constructs a new AnalyticFunction.static AnalyticFunctionnewAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression a_partitionColumn, OrderBy a_orderBy) Constructs a new AnalyticFunction.static AnalyticFunctionnewAnalyticFunction(String a_functionName, ColumnExpression[] a_partitionColumns, OrderBy[] a_orderBys) Constructs a new AnalyticFunction.static AnalyticFunctionnewAnalyticFunction(String a_functionName, ColumnExpression a_partitionColumn, OrderBy a_orderBy) Constructs a new AnalyticFunction.Methods inherited from class wt.query.SQLFunction
getArgumentAt, getArguments, getColumnAlias, newSQLFunction, newSQLFunction, newSQLFunction, newSQLFunction, newSQLFunction, setArgumentAt, setArguments, setColumnAlias
-
Method Details
-
newAnalyticFunction
public static AnalyticFunction newAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression[] a_partitionColumns, OrderBy[] a_orderBys) throws QueryException Constructs a new AnalyticFunction.
Supported API: true- Parameters:
a_functionName-a_arguments-a_partitionColumns-a_orderBys-- Returns:
- AnalyticFunction
- Throws:
QueryException
-
newAnalyticFunction
public static AnalyticFunction newAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression a_partitionColumn, OrderBy a_orderBy) throws QueryException Constructs a new AnalyticFunction.
Supported API: true- Parameters:
a_functionName-a_arguments-a_partitionColumn-a_orderBy-- Returns:
- AnalyticFunction
- Throws:
QueryException
-
newAnalyticFunction
public static AnalyticFunction newAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression[] a_partitionColumns) throws QueryException Constructs a new AnalyticFunction.
Supported API: true- Parameters:
a_functionName-a_arguments-a_partitionColumns-- Returns:
- AnalyticFunction
- Throws:
QueryException
-
newAnalyticFunction
public static AnalyticFunction newAnalyticFunction(String a_functionName, ColumnExpression a_partitionColumn, OrderBy a_orderBy) throws QueryException Constructs a new AnalyticFunction.
Supported API: true- Parameters:
a_functionName-a_partitionColumn-a_orderBy-- Returns:
- AnalyticFunction
- Throws:
QueryException
-
newAnalyticFunction
public static AnalyticFunction newAnalyticFunction(String a_functionName, ColumnExpression[] a_partitionColumns, OrderBy[] a_orderBys) throws QueryException Constructs a new AnalyticFunction.
Supported API: true- Parameters:
a_functionName-a_partitionColumns-a_orderBys-- Returns:
- AnalyticFunction
- Throws:
QueryException
-