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

public class AnalyticFunction
extends SQLFunction
implements Externalizable

Supported API: true

Extendable: false

See Also:

• Serialized Form

Field Summary

Fields inherited from class wt.query.SQLFunction

ABS, ADD, AVERAGE, BITAND, CEIL, CONCAT, CONVERT, COUNT, DATE_SQL_FORMAT, DATEDIFF, DAY_FMT, DECODE, DIVIDE, FLOOR, GET_DAY, GET_HOURS, GET_MINUTES, GET_MONTH, GET_SECONDS, GET_YEAR, HOUR_FMT, HOUR_PER_DAY, IN_STRING, LENGTH, LOG, LOWER, LTRIM, MATCH_NUMBER, MATCH_STRING, MATCH_TIMESTAMP, MAXIMUM, MINIMUM, MINUTE_FMT, MOD, MONTH_FMT, MULTIPLY, NLSSORT, NULL_VALUE, OLD_FORMAT_VERSION_UID, ROUND, RTRIM, SIGN, SOUNDEX, STDDEV, SUB_STRING, SUBTRACT, SUM, SYSDATE, TIME_DIFFERENCE_IN_DAY, TIME_DIFFERENCE_IN_HOUR, TIME_SQL_FORMAT, TIMESTAMP_SQL_FORMAT, TO_CHAR, TO_DATE, TO_DATE_FUNCTION, TO_NUMBER, TRUNC_FUNC, TRUNCATE, UPPER, UPPER_FUNCTION, YEAR_FMT

Fields inherited from interface wt.query.ColumnExpression

ADVANCED_QUERY, ADVANCED_QUERY_ENABLED, COLUMN_ALIAS, JAVA_TYPE

Fields inherited from interface wt.query.Expression

FROM_COUNT

Fields inherited from interface wt.query.RelationalExpression

BIND_PARAMETER

Method Summary

Modifier and Type	Method	Description
static AnalyticFunction	newAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression[] a_partitionColumns)	Constructs a new AnalyticFunction.
static AnalyticFunction	newAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression[] a_partitionColumns, OrderBy[] a_orderBys)	Constructs a new AnalyticFunction.
static AnalyticFunction	newAnalyticFunction(String a_functionName, ColumnExpression[] a_arguments, ColumnExpression a_partitionColumn, OrderBy a_orderBy)	Constructs a new AnalyticFunction.
static AnalyticFunction	newAnalyticFunction(String a_functionName, ColumnExpression[] a_partitionColumns, OrderBy[] a_orderBys)	Constructs a new AnalyticFunction.
static AnalyticFunction	newAnalyticFunction(String a_functionName, ColumnExpression a_partitionColumn, OrderBy a_orderBy)	Constructs a new AnalyticFunction.

Methods inherited from class wt.query.SQLFunction

getArgumentAt, getArguments, getBindParameter, getClassAttribute, getColumnAlias, getFunctionCount, getJavaType, getMaximumArgumentCount, getMinimumArgumentCount, getName, isAdvancedQueryEnabled, isAggregate, isUserDefined, list, list, newSQLFunction, newSQLFunction, newSQLFunction, newSQLFunction, newSQLFunction, readVersion, setAdvancedQueryEnabled, setArgumentAt, setArgumentAt, setArguments, setClassAttribute, setColumnAlias, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

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