Package com.spoledge.audao.parser.gql.impl.soft.func

Class Summary
Func The parent of all functions.
Func0 The parent of all 0-argument functions.
Func1 The parent of all 1-argument functions.
Func2 The parent of all 2-argument functions.
Func3 The parent of all 3-argument functions.
FuncABS ABS( x ) - returns Math.abs(x) - either long or double.
FuncACOS ACOS( x ) - returns Math.acos(x) - double.
FuncASIN ASIN(x) - returns Math.asin(x) - double.
FuncATAN ATAN( x ) - returns Math.atan(x) - double.
FuncATAN2 ATAN2( y, x ) returns Math.atan2( y, x ) - double.
FuncCEIL CEIL( x ) - returns Math.ceil(x) - long.
FuncCOS COS( x ) - returns Math.cos(x) - double.
FuncCOSH COSH( x ) - returns Math.cosh(x) - double.
FuncDECODE DECODE( expr, search1, value1 [, search2, value2 ...] [, otherwise]) - same as Oracle's DECODE function.
FuncDIV DIV( x, y ) - returns x divided by y - either long or double.
FuncEXP EXP( x ) - returns Math.exp(x) - double.
FuncFLOOR FLOOR( x ) - returns Math.floo(x) - double.
FuncGEOPT_LAT GEOPT_LAT( geopt ) .
Extracts latitude from the geopt.
FuncGEOPT_LNG GEOPT_LNG( geopt ) .
Extracts longitude from the geopt.
FuncINSTR INSTR( text, substring [, start [, occurrence ]) .
Searches for substring in the text.
FuncKEY_ID KEY_ID( __key__ ) - returns the Long id of the key or null if not assigned.
FuncKEY_NAME KEY_NAME( __key__ ) - returns the String name of the key or null if not assigned.
FuncKEY_PARENT KEY_PARENT( __key__ ) - returns the parent key or null, if no parent exists.
FuncKEY_VALUE KEY_VALUE( __key__ ) - returns the Long id or the String name of the key or null if not assigned.
FuncLENGTH LENGTH( text ) .
Returns length of the text or null if the text is null.
FuncLIST LIST( listitem* ) creates a list.
FuncLIST_JOIN LIST_JOIN( string, list ) joins a list into a string value.
FuncLN LN( x ) - returns Math.log(x) - double.
FuncLOWER LOWER( text ) .
Converts the text int uppercase.
FuncMINUS MINUS( x, y ) - returns x minus y - either long or double.
FuncMOD MOD( x, y ) - returns x modulo y - either long or double.
FuncMUL MUL( x, y ) - returns x multiply y - either long or double.
FuncNVL NVL( expr, value ) If expr is not null, then returns expr, otherwise value.
FuncNVL2 NVL2( expr, value1, value2 ) If expr is not null, then returns value1, otherwise value2.
FuncPLUS PLUS( x, y ) - returns x plus y - either long or double.
FuncPOWER POWER( x, y ) - returns Math.pow( x, y ) - double.
FuncRAND RAND() - returns random number as Math.random() returns.
FuncSIGN SIGN( x ) - returns -1, 0 or 1 (long).
FuncSIN SIN( x ) - returns Math.sin(x) - double.
FuncSINH SINH( x ) - returns Math.sinh( x ) - double.
FuncSQRT SQRT( x ) - returns Math.sqrt(x) - double.
FuncSUBSTR SUBSTR( text, start [, count ]) .
start: 1,2,3...
FuncSYSDATE SYSDATE() - returns the current timestamp - Date.
FuncTAN TAN( x ) - returns Math.tan(x) - double.
FuncTANH TANH( x ) - returns Math.tanh(x) - double.
FuncTO_CHAR TO_CHAR( date[, fmt ]) .
TO_CHAR( number[, fmt ]) .
TO_CHAR( whatever ) .
fmt: optional format - uses java.text.SimpleDateFormat for dates and java.text.DecimalFormat for numbers Converts misc types to the String type.
FuncUPPER UPPER( text ) .
Converts the text int uppercase.
GeoPtFunc1 The parent of all GeoPt 1-argument functions.
KeyFunc1 The parent of all 1-argument GAE KEY functions.
MathFunc1 The parent of all mathematic 1-argument functions.
MathFunc2 The parent of all mathematic 2-argument functions.
StringFunc1 The parent of all string 1-argument functions.
 



Copyright © 2010 Spolecne s.r.o. All Rights Reserved.