xdev.db.sql

Class Functions

java.lang.Object

xdev.db.sql.Functions

public final class Functions
extends Object

Method Summary

Modifier and Type	Method and Description
static Expression	ABS(Object value)
static Expression	AVG(Object value)
static Expression	CAST(Object rhsExpression, Object lhsExpression)
static Expression	COALESCE(Object... values)
static Expression	CONCAT(Object left, Object right)
static Expression	COUNT()
static Expression	COUNT(Object value)
static Expression	MAX(Object value)
static Expression	MIN(Object value)
static Expression	MOD(Object dividend, Object divisor)
static Expression	ROUND(Object value, int decimals)
static Expression	ROW_NUMBER()
static Expression	SUBSTRING(Object string, int start)
static Expression	SUBSTRING(Object string, int start, int length)
static Expression	SUM(Object value)
static Expression	TO_CHAR(Object expression, Object format)
static Expression	TO_NUMBER(Object expresion)

Methods inherited from class java.lang.Object

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

Method Detail

AVG

public static Expression AVG(Object value)

COUNT

public static Expression COUNT()

COUNT

public static Expression COUNT(Object value)

MAX

public static Expression MAX(Object value)

MIN

public static Expression MIN(Object value)

SUM

public static Expression SUM(Object value)

CAST

public static Expression CAST(Object rhsExpression,
                              Object lhsExpression)

ABS

public static Expression ABS(Object value)

COALESCE

public static Expression COALESCE(Object... values)

MOD

public static Expression MOD(Object dividend,
                             Object divisor)

ROW_NUMBER

public static Expression ROW_NUMBER()

SUBSTRING

public static Expression SUBSTRING(Object string,
                                   int start)

SUBSTRING

public static Expression SUBSTRING(Object string,
                                   int start,
                                   int length)

CONCAT

public static Expression CONCAT(Object left,
                                Object right)

ROUND

public static Expression ROUND(Object value,
                               int decimals)

TO_CHAR

public static Expression TO_CHAR(Object expression,
                                 Object format)

TO_NUMBER

public static Expression TO_NUMBER(Object expresion)