Uses of Class
org.apache.empire.db.expr.column.DBFuncExpr

Packages that use DBFuncExpr

Package	Description
org.apache.empire.db	This package contains the core Empire-DB implementation classes.
org.apache.empire.db.expr.compare	This package contains SQL-generator classes for compare expressions used in the where and having clause.

Uses of DBFuncExpr in org.apache.empire.db

Methods in org.apache.empire.db that return DBFuncExpr

Modifier and Type	Method	Description
final DBFuncExpr	DBColumnExpr.abs()	Creates and returns a sql-expression for the absolute abs() function.
final DBFuncExpr	DBColumnExpr.avg()	Creates and returns an aggregation function object which returns the average value for the current expression over a group of rows.
final DBFuncExpr	DBColumnExpr.ceiling()	Create and returns an expression for the SQL-function ceil()
final DBFuncExpr	DBColumnExpr.day()	Creates and returns an function object that calculates the day of a date value.
final DBFuncExpr	DBColumnExpr.floor()	Create and returns an expression for the SQL-function floor()
final DBFuncExpr	DBColumnExpr.format(String format)	Formats a column-expression using a format string This function is intended for formatting numbers.
protected final DBFuncExpr	DBColumnExpr.getExprFromPhrase(DBSqlPhrase phrase, Object[] params)
protected DBFuncExpr	DBColumnExpr.getExprFromPhrase(DBSqlPhrase phrase, Object[] params, DataType dataType)	Creates a new DBFuncExpr from a given SQL-PRHASE and optional additional parameters.
final DBFuncExpr	DBColumnExpr.indexOf(Object str)	Creates and returns a sql-expression that returns the position of a string in the current column expression.
final DBFuncExpr	DBColumnExpr.indexOf(Object str, int fromPos)	Overloaded.
final DBFuncExpr	DBColumnExpr.indexOf(Object str, DBExpr fromPos)	Creates and returns a sql-expression that returns the position of a string in the current column expression.
final DBFuncExpr	DBColumnExpr.length()	Creates and returns a sql-expression that returns the string length of this expression.
final DBFuncExpr	DBColumnExpr.lower()	Creates and returns a function object which converts the current expression to lower case.
final DBFuncExpr	DBColumnExpr.max()	Creates and returns an aggregation function object which returns the maximum value for the current expression over a group of rows.
final DBFuncExpr	DBColumnExpr.min()	Creates and returns an aggregation function object which returns the minimum value for the current expression over a group of rows.
final DBFuncExpr	DBColumnExpr.modulo(Object divisor)	Creates a sql-expression for the modulo or mod() function.
final DBFuncExpr	DBColumnExpr.month()	Creates and returns an function object that calculates the month of a date value.
DBFuncExpr	DBColumnExpr.prepend(Object value)	Puts a value or expression before the current expression
final DBFuncExpr	DBColumnExpr.replace(Object match, Object replace)	Creates and returns a sql-expression for the replace(...) function.
final DBFuncExpr	DBColumnExpr.reverse()	Creates and returns a sql-expression for the reverse(...) function.
final DBFuncExpr	DBColumnExpr.round(int decimals)	Creates and returns an function object that rounds a number espression with the given decimals.
final DBFuncExpr	DBColumnExpr.stringAgg(String separator)	Creates and returns string aggregation expression
final DBFuncExpr	DBColumnExpr.stringAgg(String separator, DBOrderByExpr orderBy)	Creates and returns string aggregation expression
DBFuncExpr	DBColumnExpr.substring(int pos)	Overloaded.
DBFuncExpr	DBColumnExpr.substring(int pos, int count)	Overloaded.
DBFuncExpr	DBColumnExpr.substring(int pos, DBExpr count)	Overloaded.
final DBFuncExpr	DBColumnExpr.substring(DBExpr pos)	Creates and returns a sql-expression for the substring(...) function.
DBFuncExpr	DBColumnExpr.substring(DBExpr pos, int count)	Overloaded.
final DBFuncExpr	DBColumnExpr.substring(DBExpr pos, DBExpr count)	Creates and returns a sql-expression for the substring(...) function.
final DBFuncExpr	DBColumnExpr.sum()	Creates and returns an aggregation function object which calculates the sum for the current expression over a group of rows.
final DBFuncExpr	DBColumnExpr.trim()	Creates and returns a sql-expression for the trim() function.
final DBFuncExpr	DBColumnExpr.trimLeft()	Creates and returns a sql-expression for the ltrim() function.
final DBFuncExpr	DBColumnExpr.trimRight()	Creates and returns a sql-expression for the rtrim() function.
final DBFuncExpr	DBColumnExpr.trunc(int decimals)	Creates and returns an function object that truncates a number espression with the given decimals.
final DBFuncExpr	DBColumnExpr.upper()	Creates and returns a function object which converts the current expression to upper case.
final DBFuncExpr	DBColumnExpr.year()	Creates and returns an function object that calculates the year of a date value.

Uses of DBFuncExpr in org.apache.empire.db.expr.compare

Fields in org.apache.empire.db.expr.compare declared as DBFuncExpr

Modifier and Type	Field	Description
protected DBFuncExpr	DBCompareColExpr.function